Forum Discussion
Be-Rad
Aug 07, 2019Copper Contributor
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 char...
- Aug 07, 2019
=LEFT(A1,LEN(A1)/2)
Detlef_Lewin
Aug 07, 2019Silver Contributor
=LEFT(A1,LEN(A1)/2)
Be-Rad
Aug 08, 2019Copper Contributor