how to merge 2 colums

M

Michael

Mendel

Use the Concatenate function.

If the area code is in A1 and the Tel # is in A2.
Click in A3 and type =A1&A2.

Have a look at the result, if it is OK then drag A3 down
the rest of the column.
Regards
Michael
 

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

Concatenate when pasting. 0
concatenate values 4
get a cell reference as a result of an If Function 1
Merging from an Excel file with graphics 1
Conditional format entire column 3
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
Page numbering with Merged Document and IF statements 1
Altered pasting functionality 3

Top