Jeff

After concatenating the cells into one using the =A1 & B1 etc. copy those
formula cells then, in place, paste specialvaluesOKEsc.

You can now delete the original cells.

"Merging" cells will retain only the data from the top leftmost cell.

"Merged" cells cause no end of problems with copying, sorting, filtering.

Leave that feature alone as much as possible.


Gord Dibben Excel MVP

On Wed, 22 Jun 2005 15:18:02 -0700, "JeffC"
wrote:

I also have the same question. I have used the methods listed here and have
successfully displayed all text in one cell with this formula. However, if I
delete the adjoining cells that the formula refers to, I get a #REF# error.

Is there a way to actually merge text from multiple cells in to a single cell?

Any help would be greatly appreciated!

"momtoaj" wrote:

In column D use the formula

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

The " " would put in your spaces in between the names.
Then go to column D & do Edit Copy, move to column A & do
Edit Paste. Then you should be able to delete columns B,
C & D.

Hope that helps!

-----Original Message-----
I have first, middle, and last names in A, B, and C. I
want to merge
everything into A. Ho do I do that?
.