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 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)
Brilliant Thank you, Whilst your here, If i had the same need on another List for Text with two words and a number, so "Example Example 2" Can I do the same and only have the number show please.
jamescosten I'll have to think about that. Possibly ganeshsanap will know cos he's very clever.