RE: breaking up a phone number

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi
We can do in different ways

column b = left(A,3)
column c = mid(A,5,3)
column d = right(A,4)


"maximus73" wrote:

>
> 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?action=getinfo&userid=25877
> View this thread: http://www.excelforum.com/showthread.php?threadid=392596
>
>
.

Relevant Pages

  • RE: breaking up a phone number
    ... Gary's Student ... "maximus73" wrote: ... > any suggestions on how to accomplish this? ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: breaking up a phone number
    ... 'Next' --> select the 'Other' button and enter a hyphen mark in the box by ... column C would equal the Prefix.. ... > any suggestions on how to accomplish this? ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: New a little help
    ... worked like a champ! ... maximus73's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25877 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)