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 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
=LEFT(A1,LEN(A1)/2)
2 Replies
- Detlef_LewinSilver Contributor
=LEFT(A1,LEN(A1)/2)
- Be-RadCopper Contributor