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.
 
Hi Kevin!

Use:
=A1&SUBSTITUTE(B1,"-","")
Click to expand...
Ooppss!

Forgot about the dash "-" ....... *redfaced*

Clarence aka ~~~
MY EMAIL IS A DUD due to Spam
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose and Fill? 7
Matching Multiple Columns 4
Word Create a Phone Book using MailMerge in word 2007 0
Calculate total by row number 4
Add incremental character to cell value at change in value 449becomes 449-A 510 becomes 510-B 2
look up number in column 2
Pivot Tables by Macro 2
Function to uniformerly format different phone numbers 7

Back
Top