Formula or funtions for phone numbers

[tlang]

Hello,
I have 3 columns the first one is area code then first 3 numbers of phone number and then last four numbers. What is the formula or function to place all three columns into one column? Thanks for help in this matter.
Tammy

 

[JoeMo]

Assuming you want this in format xxx-xxx-xxxx:

Excel Workbook
	A	B	C	D
1	512	733	1234	512-733-1234
2	800	877	4567	800-877-4567
Sheet3

Copy D1 down.

 

[Dartagnan]

Here is an example.
=A1&B1&C1

You can also create () around the area code and include spaces and the dash as follows:
="("&A1&") "&B1&"-"&C1

 

[T. Valko]

Hello,
I have 3 columns the first one is area code then first 3 numbers of phone number and then last four numbers. What is the formula or function to place all three columns into one column? Thanks for help in this matter.
Tammy

If you have:

A1 = 123
B1 = 456
C1 = 7890

This formula entered in D1:

=A1&B1&C1

Will return this string: 1234567890

Is that how you want it or do you want it like a "typical" are code + phone number:

(123) 456-7890

If you want the latter then use this formula:

="("&A1&") "&B1&"-"&C1

 

[T. Valko]

If you have:

A1 = 123
B1 = 456
C1 = 7890

This formula entered in D1:

=A1&B1&C1

Will return this string: 1234567890

Is that how you want it or do you want it like a "typical" are code + phone number:

(123) 456-7890

If you want the latter then use this formula:

="("&A1&") "&B1&"-"&C1

Another option:

=TEXT(A1&B1&C1,"(000) 000-0000")