Re: breaking up a phone number


Another option (for other readers of this thread) is to use the Text to
Columns feature. Insert three blank columns (if needed) next to your
phone number column to receive the data. Highlight the range of phone
numbers and click Data>Text to Columns... Choose "Delimited" and
click Next> Set the delimiter as "Other" and enter the dash "-" and
click Finish.

Now all of your phone numbers are separated into three columns. At
this point, you could (if desired) delete Column A.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15101
View this thread: http://www.excelforum.com/showthread.php?threadid=392596

.

Relevant Pages