Software

Ask something
Discussion Locked

MRGING 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 bishopca

Good Question, but don't merge the cells. You need to write a formula to combine the cells.

In cell B2 write =C2&" "&D2
This will combine the contents of cell C2 and D2 with a space between the cell contents.

One caution though - format cells C2 and D2 as text. You can add additional cells by adding the & character and typing the reference.

Then copy the formula down the column. Using this technique you can preserve the original and quickly get your desired results.

Good Luck!

by el flush san

You can also use the formula
=concatenate(trim(a1),", ",trim(b1),", ",trim(c1))
where a1, b1 and c1 are the three cells that you wish to join together.
The trim function will remove all preceeding and trailing spaces in the cells that you are using (eg a1, b1, c1)
The commas are added by ", ". If you don't need commas then just
=concatenate(trim(a1), trim(b1), trim(c1))

This discussion is closed to new replies.