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

I am copying phone numbers from a web site and pasting onto my
spreadsheet. When I copy the number it looks like 1(216) 555-4847. My
spreadsheet is set up so that the 1 goes in column B, the area code
minus ( ) goes in column C and the phone number minus the space and
dash go in column D.
Is there any type of formula that will allow me to paste into column B
and the area code and phone number are automatically moved into C & D?
I am not worried about deleting ( ), the space and dash. I can always
do a "Find and Replace". I know that I am streaching it but this would
save me soooo much time.
Hope there is a way.
Thanks,
Shaety


--
SHAETY
------------------------------------------------------------------------
SHAETY's Profile: http://www.excelforum.com/member.php...o&userid=31650
View this thread: http://www.excelforum.com/showthread...hreadid=513395