I am trying to unite one column with another column

  • Thread starter Thread starter czar
  • Start date Start date
C

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.
 
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
 
Back
Top