Merging cells

A

Al_baker

I am trying to clean up an excel doc by merging data in many cells into one
and deleting the original cells. THis however cannot be done it seems as the
references are then invalid?

Thanks for any help......
 
C

CLR

That would be true..........whatis it that you are really wanting asthe end
result?..........perhaps there's another way.........

Vaya con Dios,
Chuck, CABGx3
 
A

Al_baker

There is information regarding a projects requirement sacttered over many
cells and I want this info in one. Rather than copying and pasting from all
of these seperate cells, is there another way?

Thanks again
 
C

CLR

Perhaps CONCATENATION would serve you.........
ie: if A1=Merry and B1=Christmas, then this formula in C1 would return
Merry Christmas...........

=A1&" "&B1

hth
Vaya con Dios,
Chuck, CABGx3
 
A

Al_baker

Thanks for the advice,

one last thing, would that still not make the refs redundant?

Thanks again
 
Top