HI
I am looking to remove numbers from a cell containing a text string also. Numbers are always seperated form the text by a space but there can be other spaces in the text.
Example Data would be
A
109200 Bobs Farm
3445 Manly
34298 Charlottes Pass
I would want the cells to just read
Bobs Farm
Manly
Charlottes Pass
Respectively, The length of numbers will also change regularly - Any help at all would be awesome
is the number always at the front seperated by a space?
if so then formula like below can seperate it out
assuming cell is in A1
Formula:
Please Login or Register to view this content.
Last edited by humdingaling; 01-12-2016 at 02:04 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
As per your description.
If Text string is in A1
Then
B1=TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)))
or
B1=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",50)),101))
Last edited by shukla.ankur281190; 01-12-2016 at 02:43 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you so much
Glad to help you and thanks for feed back. Please mark as it solved and add reputation by clicking star * icon on your left corner on your screen.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks