How to remove numbers from a column but keep letters?
I am trying to edit an excel sheet but cannot figure out how to delete all numbers in one column without going through and deleting each one. For example, one cell in the column looks like 87684-Emily. How would I delete 87684- and keep just emily? (I need to do this for an entire column). Any help would be greatly appreciated. Thanks!
If all of them has dashes, try this on B1 and drag down, assuming your column with data is on column A.
Formula:
Please Login or Register to view this content.
If it is always 5 number and a dash you can create a column next to that one and use =REPLACE(A1,1,6,"")
Edit: I tried and it didn't work.Originally Posted by glennchung
If all of them has dashes, try this on B1 and drag down, assuming your column with data is on column A.
Formula:Please Login or Register to view this content.
It is not always 5 numbers. It varies..
Last edited by kairalynn; 09-11-2014 at 07:12 PM.
=RIGHT(A1,FIND("-",A1)-1), that should work for sure, could you plz upload your sample file so better help could be provided?
This VBA will do it but its tad slow I am certain it can be edited to enhance performance.
Please Login or Register to view this content.
Last edited by Mr_Bill; 09-11-2014 at 07:50 PM.
Please provide a few more samples of what your data looks like, so we dont have to guess
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
maybe this
=REPLACE(A1,1,FIND("-",A1),"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
This should work. The one in post #2 would not work because the FIND formula is returning a value counting from the left (instead of from the right) to find the dash. Good work, AlKey.
Deleted post
Last edited by AlKey; 09-11-2014 at 08:49 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks