Hi Guys,
I recently posted on how to remove the numbers from a cell and only keep the words. The reporting has been changed a bit now so I am hoping someone can help me on this.
eg Cell A1 = 1343343:Excel Forum
I want Cell B1 to be just "Excel Forum" thereby removing all the numbers.
Help please!
hi dksodhi. based on just 1 eg, i would say:
=MID(A1,FIND(":",A1)+1,255)
could you provide us more egs for us to see a pattern. it could be much more complicated
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi, I have attached a Sample File.
Thanks.
so maybe:
=LEFT(A1,FIND(":",A1)-1)
or if you need the ":", then:
=LEFT(A1,FIND(":",A1))
Awesome.
Works perfectly......Thank you so Much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks