LinkBack URL
About LinkBacks
Need help cropping text. I have the following text in cells and i'm trying to get just the names....basically everything before the space and the comma... Help is appreciated!
Andrew , 123 Main Street
Jill , 456 1st Street
Brian , 789 Last Street
Need help cropping text. I have the following text in cells and i'm trying to get just the names....basically everything before the space and the comma... Help is appreciated!
Andrew , 123 Main Street
Jill , 456 1st Street
Brian , 789 Last Street
If data is in A2 down try this formula in B2 copied down
=TRIM(LEFT(A2,FIND(",",A2)-1))
Audere est facere
try formula:
=LEFT(A2,FIND(" ,",A2)-1)
where A2 has first string.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Both formulas will work. You guys rock!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks