Hi

Try this with the number in A1

In B1
=MID(A1,1,3)

In C1
=MID(A1,5,3)

In D1
=MID(A1,9,4)

Select B1:D1 and copy down


--
Regards Ron de Bruin
http://www.rondebruin.nl


"maximus73" wrote in message
...

I need to break up a phone number into three different columns. I have
column A that contains the phone number xxx-xxx-xxxx, I need to split
that up into three different columns. Column B would equal the area
code... column C would equal the Prefix.. and column D would equal the
digits..

any suggestions on how to accomplish this?

thanks


--
maximus73
------------------------------------------------------------------------
maximus73's Profile: http://www.excelforum.com/member.php...o&userid=25877
View this thread: http://www.excelforum.com/showthread...hreadid=392596