LinkBack URL
About LinkBacks
Hello. If I have a bunch of cells like this: 1243 Jimmy, 14567342 Ricardo, 1324 Billiam etc, is there a way I can write a formula that only returns the letter characters? Thanks.
Hello. If I have a bunch of cells like this: 1243 Jimmy, 14567342 Ricardo, 1324 Billiam etc, is there a way I can write a formula that only returns the letter characters? Thanks.
You use 'text to columns' function from excel
Or use this formula;
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks