George Gee:
Thank you so much for your help. This worked wonderfully, and you are a hero
in the office.

kbkst

George Gee wrote:
Look at: Edit Find and Replace.
For example:
To remove the minus sign:
Highlight all the phone numbers,
On the 'Find' tab, type -
On the 'Replace' tab, leave blank.
Click 'Replace all'.
Repeat for the () and space.
Practise on a copy of your file first!

If you need more help with this, post back.

George Gee

I am cutting & pasting phone numbers onto my excel spreadsheet. When they
are pasted, they look like this: (216) 433-7623. I need them to look like
[quoted text clipped - 6 lines]
Thanks,
kbkst

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