Forum Discussion
Right Function but with multiple digit numbers
I have a Column that is Named "Example 2", "Example 12" etc. I want a calculated column to trim the numbers from the text. Obviously Right doesnt work for me. Any toher way I could accomplish this?
Apologies I meant to say in the columns are items with those values. So i want to trim the values not the columns.
jamescosten in my example below Substring is a calculated column and the formula is =LEFT(Project,FIND(" ",Project)-1)
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP (and classic 1967 Morris Traveller driver)
- Ok so using your example i did this:
=RIGHT([Training Issued],FIND([Training Issued]," ")-1)
The Logic Being it finds the Trining Issued Text, "Example" and the the gap after so it shoudl only leave the numbers. Im not sure what the -1 is doing. Anyway this didnt work, it shows #VALUE.- When i say trim the numbers in my original post I meant i want them not the text, I want to keep only the numbers.
jamescosten then it's a different formula:
=RIGHT(Project,LEN(Project)-INT(FIND(" ",Project)))
You can read more about the FIND function here.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP (and classic 1967 Morris Traveller driver)