George:
I tried this but not working. I am actually starting with B2, C2, D2.
Please let me know what columns to post these in. I am not very up on the
excel spreadsheet and could really use your help.
Thanks!

George wrote:
If the positions of the numbers are fixed you can use the text functions
left, mid, right
B1 = LEFT(A1,1)
C1 = MID(A1,3,3)
D1 = SUBSTITUTE(RIGHT(A1,8),"-","")

This can be a little tricky if for example your country code
varies from 1 digit to 2 digits. Then you need something like this

B1 = LEFT(A1,FIND("(",A1)-1)
C1 = MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
D1 = SUBSTITUTE(RIGHT(A1,8),"-","")

Copy the formulas down then...
Once your done copy and paste special values over themselves

George

This may not be able to be done, but it doesn't hurt to ask.

[quoted text clipped - 11 lines]
Thanks,
Shaety

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200602/1