Merging Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I merge two columns without losing information in either column?
 
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best solution to merge multiple Outlook contacts easily 2
Merging text cells 1
Merging Excel Cells 2
Merging multiple columns into one column (dynamically) 1
Sharing workbooks limitations - Merged Cells 12
sorting two columns of merged cells 1
Cell names of merged cells 1
VBA set thick borders around non empty cells in range 0

Back
Top