format phone numbers ?
i have a list of phone numbers in excel 2007 (000) 000-0000. I need to make them be like this 0000000000.
i ahev tried to format cell and put in 10 0. but it did nto work i have so many of them i do not want to do this by hand need help
thank you so much for helping me
i am using office 2007 but have to share it with someine who useing 2003
Where the numbers typed in with brackets and dashes?
Can you do a find/replace? and replace "(", ")" and "-" with nothing (i.e. leave Replace With field blank).
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
the numbers look like this (000) 000-0000
i need a cell next to it with 0000000000
The formula
=VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ",""),"(",""),")",""),"-",""))
should do it.
If its a one time project, delimited Text to Columns followed by simple concatination should work.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thank You
Thank You So Much
FYI:Originally Posted by hotpinkstef
Edit|Replace will pull up the Replace Dialogue window....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks