Excel

K

Kevin

Can anyone tell me how to:

Add the area code in column A (510)
to the phone number in column B (339-7777)

to end up with a new column 5103397777

Thank you
 
C

Clarence Crow

Can anyone tell me how to:

Add the area code in column A (510)
to the phone number in column B (339-7777)

to end up with a new column 5103397777

Thank you
Click to expand...

use the CONCATENATE function. Read how to in the HELP section.

Clarence aka ~~~
NB:MY EMAIL DOESN'T work due to Spam.
 
N

Norman Harker

Hi Kevin!

Use:
=A1&SUBSTITUTE(B1,"-","")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top