breaking up a phone number

M

maximus73

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

any suggestions on how to accomplish this?

thank
 
W

William Horton

Column A contains the phone # in the format XXX-XXX-XXXX
Column B =LEFT(A12,3)
Column C =MID(A12,5,3)
Column D =RIGHT(A12,4)

Hope this helps.

Thanks,
Bill Horton
 
L

Lomax

one way,

select column "A". Go to Data / text to columns/delimited / select other
for the delimiter and put in the "-" as your sample shows.

It should put the results in a, b & c.

Hope this helps.

lomax
 
Top