Excel

  • Thread starter Thread starter Kevin
  • Start date Start date
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
 
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.
 
Hi Kevin!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top