Re: Phone Number Formatting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Brant Nyman" <BrantNyman@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 25 Aug 2005 09:08:08 -0700

This works great too. Thanks!

"Excel_Geek" wrote:

>
> Say the column of your ########## numbers starts in A1. Type this
> formula into B1, and copy it down to the bottom of the column:
>
> ="("&LEFT(A1,3)&")"&" "&MID(A1,4,3)&"-"&RIGHT(A1,4)
>
> This will give you (###) ###-####. If you don't want the space, you
> can remove the ...&" "& part of the formula.
>
> If you want to get rid of the formulas, copy this new column and paste
> special --> values.
>
> Note that this will be text-formatted.
>
>
> --
> Excel_Geek
>
>
> ------------------------------------------------------------------------
> Excel_Geek's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26423
> View this thread: http://www.excelforum.com/showthread.php?threadid=399052
>
>
.

References:
- Phone Number Formatting
  - From: Brant Nyman
- Re: Phone Number Formatting
  - From: Excel_Geek

Prev by Date: Re: Percent Variance Formula
Next by Date: RE: How to add entires in column based on another column...
Previous by thread: Re: Phone Number Formatting
Next by thread: Re: Phone Number Formatting
Index(es):
- Date
- Thread

Relevant Pages

Re: RealPHX.com
... > just go to www.realphx.com and scroll to the bottom, ... > there's a link to get rid of it all realphx ads ... >> on a link in a friend's profile. ...
(microsoft.public.security.virus)
Re: Cant Remove Cookies ??
... My reply is at the bottom of your sent message: ... > Woo Hoo! ... > That got rid of dem pesky files. ... Prev by Date: ...
(microsoft.public.windowsxp.help_and_support)
Re: Still have red x
... My reply is at the bottom of your sent message: ... > My daughter and I have tried everything that has been suggested to ... > get rid of the red x. ... Prev by Date: ...
(microsoft.public.windowsxp.help_and_support)
Re: Money Calculation
... Hi Alan, ... Get rid of #N/A in column T then the formula I posted should work. ... daddylonglegs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30486 ... Prev by Date: ...
(microsoft.public.excel.misc)
first page blank problem
... when viewing the dvi there is a blank page with a small 1 in ... the top left corner and a larger 1 at the bottom center. ... rid of the first blank page? ... Prev by Date: ...
(comp.text.tex)