Forum Discussion

Be-Rad's avatar
Be-Rad
Copper Contributor
Aug 07, 2019
Solved

Extract Characters from Left End of Cell

I have some cells that contain either 3 or 4 characters.  I need to extract the first character if the total number of characters is 3 and extract the first 2 characters when the total number of characters if 4.  I have played around with the LEFT function but am not sophisticated enough to get the correct results.

When cell is "1234", then extract "12"

When cell is "ABC", then extract "A"

 

ty,

Be-Rad

Resources