function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Michalis MantouvalosMichalis Mantouvalos 

Remove first Letter from a text value using Formula

Hi, 

Does anyone knows how to remove the first letter of a text value using a Formula? 

For example, lets say we have the text : "B0000000321"

I want to trim it down to just : "0000000321"

A function that removes only the letters from a text  (and leave the numbers) would also be helpfull.

Thank you

Best Answer chosen by Michalis Mantouvalos
CharuDuttCharuDutt
Hii Michalis 
Try Below Formula 
TRIM(right(FieldName , (LEN( FieldName) - 1)))
Please Mark It As Best Answer If It Helps
Thank You!
 

All Answers

CharuDuttCharuDutt
Hii Michalis 
Try Below Formula 
TRIM(right(FieldName , (LEN( FieldName) - 1)))
Please Mark It As Best Answer If It Helps
Thank You!
 
This was selected as the best answer
Suraj Tripathi 47Suraj Tripathi 47

Hi Michalis,

 

TRIM(RIGHT(Name, LEN(Name)-1 ))
 

Please Mark it as Best Answer, if it helps.

Thanks
Jonathan Lynch 1Jonathan Lynch 1

Hey Suraj!

You answer also helped me out a ton! My problem did have a picklist as the FieldName and this was my solution in case it helps others:

 

TRIM(right(TEXT(FieldName) , (LEN( TEXT(FieldName)) - 4)))