how to merge data in excel

[apcandmacuser]

Hello
I am trying to import telephone numbers into a new program. I exported the existing numbers from the old software and it created a csv file that has the area code and phone number in seperate fields, whereas, the new program is expecting to import the entire number into 1 field. I open the file with excel, but cannot figure out how to merge the 2 fields into 1. I can merge 1 record at a time, but I have hundreds of numbers and would prefer to select the whole area code cell column and add (not sum) it to the front of the rest of the number. Any hints?

 

[dawnd3]

You want to use the "Concatenate" function in a 3rd field.

=Concatenate(A1,B1)

If you need a dash you would do this

=Concatenate(A1," ",B1)

Then, after, you drag the formula all the way down to copy it to the rest of the list.

THEN you want to copy the new phone column and paste special, values only into a new field so that you can export it. (if you don't do that, the new phone field is really seen as a formula and not a value.

I hope this helps, let me know if I wasn't clear on something.

Dawn

http://www.calliopeconsulting.net