Merging Cells

F

Frank Kabel

Hi
only possible with VBA

--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag
How do I merge two columns without losing information in either
Click to expand...
column?
 
A

AlfD

Hi!

I'm not sure what you mean by merge.
e.g. A1 has "XYZ" and B1 has "ABC" then C1 = A1& B1 will show "XYZABC"
But if you want simply to display the 2 columns as if they were 1 an
have "XYZABC" displayed, that would need either a helper column (like
above) or VBA.

Al
 
Top