merge cell hlep

  • Thread starter Thread starter k. danzig
  • Start date Start date
K

k. danzig

I have several sheets where by some mistake one column that should have had
long comments wrapped, has them split into individual cells. the format is
like this:

column_a column_b column_c column_d

id. data data comment line 1
comment line 2
etc.

if it was imported correctly I can sort the sheet by any column and keep all
comment lines intact. As they are seperate cells I only keep the first line.
Merge obviously doesn't help as it deletes the info in other cells...

Ideas for a better merge - or a macro?

The number of lines varies, there is always a blank at the end, and the are
hundreds of occurrances...
 
Hi,

If you know that the comments which should have been in
one cell say B10 have been split say from B10 to H10. You
can insert a blank column before B10 and put the formula:
=B10&C10&D10&E10....etc. Once this displays the full
comment in one cell then copy the cell and paste value in
the same cell. You can insert the space in the formula to
get the split words proerly.

Sumedh Paradkar
 
Try concatenating the four columns and then trimming the
blanks with:
=TRIM(CONCATENATE(A1,B1,C1,D1))
 
Back
Top