I am trying to unite one column with another column

[czar]

Hi,

I have a spreadsheet of contacts with the names, company,
fax area code, fax local number in separate columns. And I
am trying to unite the two columns(fax area code & fax
local number) to be just on one column.
Is anybody can help. I appreciate it.
Thanks.

 

[Dave R.]

You can join these with something like =A1&B2 if the area code in A1 and fax
# in B2. You can insert characters (including spaces) by putting &"text or
space"& in between them.

If the area code is a number like 916 and not (916), and the phone # is
555-1212, you can join them with parenthesis with:
="("&A1&")"&" "&b2

and it will look like (916) 552-1212