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?
jamescosten sorry, I don't really understand your question. Are you saying you want to trim the column headers? That isn't possible. Or is that you have several columns in your list and you want to trim the data that is in each column?
- 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.
