LinkBack URL
About LinkBacks
Good morning,
This should be easy for a guru which I'm not. I'm trying to pull phone numbers out of a column of text data. The format of the phone is always ###-###-####. Any help will be appreciated. Thank you.
Good morning,
This should be easy for a guru which I'm not. I'm trying to pull phone numbers out of a column of text data. The format of the phone is always ###-###-####. Any help will be appreciated. Thank you.
if all the characters are numbers, you can probably use =substitute()...
=SUBSTITUTE(A1,"-","")
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
My info is address related. City, State, Zip, etc. The only thing that discerns my phone numbers are the dashes. Your formula just removed the dashes from my phone numbers. I appreciate your idea regardless. Thanks.
hi db3712, perhaps:
=MID(A1,SEARCH("???-???-????",A1),12)
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
That did it. Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks