get the last character from a string after a character in SharePoint Calculated Column
ROY-AMD-BOL-727
I am trying to extract the last letters after the character "-".
Solution
You could use this formula.
=RIGHT([test],LEN([test])-FIND("-",[test],FIND("-",[test],FIND("-",[test])+1)+1))
Result:
- How can I see all the SharePoint Sites a user is an owner of with Microsoft Graph?
- HTTPError: 403 Client Error: Forbidden for url via Office365-REST-Python-Client
- Add borders to specific rows in Sharepoint Lists
- Sharepoint Permissions Limit
- Access sharepoint folders in R
- Graph API : How can I get Sharepoint webhook resourceData Id?
- Get the preview URL in SharePoint Document library via REST API
- Search driveItem with query of Document-ID
- Get SharePoint ListItemId by Document-ID in MS Graph API C# SDK
- Opening an Excel document from SharePoint using PowerShell
- SharePoint Copying Macro Enabled Excel File Using JavaScript
- obtain item-id for microsoft graph api
- Power Automate - Compare SharePoint List with Excel file and delete existing values
- Upload a file from local drive to Sharepoint Onpremise
- SPFX get Microsoft Outlook room events using Graph API
- SharePoint get content from list
- How to retrieve a specific SharePoint online site using graph api and PowerShell
- How to send the name of the person who edits the form in sharepoint using powerapss?
- How to improve the processing speed for updating Sharepoint List value from VBA (ADODB)
- Logic App PDF File from Sharepoint uploading to Azure Blob is Blank
- VS2015 build error: Cannot add the specified assembly to the global assembly cache
- SharePoint 2016 PWA site not working
- SharePoint API: 2003 vs 2007
- Does the Current Sharepoint Online REST API Work With ANY Other Versions of Sharepoint?
- How to Download a file from Sharepoint using .NET?
- Download SharePoint file from Microsoft Graph API using "sourcedoc" ID
- I got error 404 Not Found when adding metadata to file in sharepoint via Microsoft Graph API SDK Java
- Get search scope and redirect to external search service in Sharepoint
- How to use VBA to insert a photo IN a cell
- Graph API returns 0 drives for a SharePoint Team Site, on which there is a shared folder and its subfolders with files