Software

Ask something
Discussion Locked

MERGING CELL IN EXCEL

0 helpful
5 replies

by wizstorm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I wonder if there is a way to merge several columns in excel into one column
for instance I have a worksheet for contacts
and the address information is separated in three columns 1. =address 2.=city 3.=state
is there any way to make these columns one?

5 replies

by peyison

There is not a way to do this automatically, but you can do it manually. If address is in column A, city is in column B and state is in column C - put this formula in cell D1 and copy it down column D:

=A1& " " & B1& ", " &C1

This combine the values in the three columns, and put a space between address and city, and a comma and a space between city and state.

Once you have copied the formula down, select the cells in column D that have the formula, do a Copy, then from the main menu select Edit -> Paste Special..., select the Values option in the Paste section, and press OK.

Then you can delete columns A-C.

Hope this helps.

by hotzmiller

Peyison is correct. I was looking for the same answer. Please give him the points, he saved me a lot of wasted time!

Skip

This discussion is closed to new replies.