Combining data in two columns into one column

Topic

New Reply

Using MS Excel 2000

My worksheet has 400+ rows. In column A are first names and last names are in column B. I want to have first and last names in one column. Is there a way to do this other than manually?

Reply | Quote

Replies

Using MS Excel 2000

My worksheet has 400+ rows. In column A are first names and last names are in column B. I want to have first and last names in one column. Is there a way to do this other than manually?

Hi Malcolm

In cell C1 type:

= A1 & ” ” & B1

And copy down using the fill handle to C400 +

Reply | Quote

Hi Malcolm

In cell C1 type:

= A1 & ” ” & B1

And copy down using the fill handle to C400 +

Thank you – That’s works fine. But there’s a BUT!

When I copy and paste column C into a new worksheet the first and last names are replaced by #REF! Having achieved the object is it possible to remove the dependence on the formula?

Reply | Quote

Thank you – That’s works fine. But there’s a BUT!

When I copy and paste column C into a new worksheet the first and last names are replaced by #REF! Having achieved the object is it possible to remove the dependence on the formula?

Not a problem, copy column C and then in the new worksheet select the range and click EDIT—> Paste Special and then select Values

This converts it for you…..

Reply | Quote

Not a problem, copy column C and then in the new worksheet select the range and click EDIT—> Paste Special and then select Values

This converts it for you…..

That solves the whole issue for me. Thank you very much for your assistance. The drinks are on me when we meet!

Malcolm

Reply | Quote