Home > Computers > My Excel Phone Number Trick

My Excel Phone Number Trick

This is my little way of changing the way a phone number is displayed in a cell not using number formating (i.e. General).

Cell A1 contain 5555555555. I want it to display as (555) 555-5555. So in B1 I enter the following formula:

=”(“&LEFT(A1,3)&”) “&MID(A1,4,3)&”-“&RIGHT(A1,4)

Right click B1 & select copy. Right click A1 & select Paste Special. Select Values & click OK. Now delete cell B1.

Advertisements
Categories: Computers Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: