Merging 2 columns..area code- phone #

[Guest]

I have 2 columns..1 being area code, the other being phone #....how can i merge the 2??

 

[Frank Kabel]

Hi Stover
try
=A1 & "-" & B1
and copy this down. you may replace the seperator

Frank

 

[Guest]

thanks Frank..but where do I put
=A1 & "-" & B1


----- Frank Kabel wrote: -----

Hi Stover
try
=A1 & "-" & B1
and copy this down. you may replace the seperator

Frank

 

[Frank Kabel]

Hi Stover
if your current entries are stored in column A and B put the formula
for example in C1 and copy this down.
After this you may select column C, copy this range (CTRL+C) and paste
it using 'Edit - Paste Special - Value' to get only the combined values
without formulas

Frank

 

[Guest]

Thanks Frank....got it now..

----- Frank Kabel wrote: ----

Hi Stove
if your current entries are stored in column A and B put the formul
for example in C1 and copy this down
After this you may select column C, copy this range (CTRL+C) and past
it using 'Edit - Paste Special - Value' to get only the combined value
without formula

Fran


Stover wrote

 

[JE McGimpsey]

Frank gave you a good method using a "helper column". If you have to do
it frequently, you might look at a macro to combine the columns in-place
at

http://www.mcgimpsey.com/excel/mergedata.html

 

[Frank Kabel]

Hi Stover
should be easy to do Try the following to make copy+pase a little
bit easier
- enter the formula in C1
- double-click on the lower right corner of the selection mark. This
will fill the formula down
- Select the entire column C (clicking on the heading 'C')
- hit CTRL+C
- goto 'Paste - Special' and choose Values

So all in all 5 steps

For another solution you'll need VBA

Frank

 

[Bill Ridgeway]

Didn't se the original post so I hope this will help. the answer may be
concatenation (posh word for join).

ColumnA ColumnB ColumnC
Bill Ridgeway =a2&" "&b2
This takes the value of A2 adds a space and adds the value of B2

Copy the formula down

Highlight ColumnC
Paste
Highlight ColumnC
Click on <Edit> Paste Special><Values>OK>

ColumnC now contains date merged from Column A & B and those columns may be
deleted.

You can do more than this simple concatenation.

Regards.

Bill Ridgeway
Computer Solutions

There is alot of cutting and pasting..anything easier?? can I not just

select the 2 columns and somehow merge them