asked on Merge and preserve formatting
I'm trying to convert multiple cells of an excel spreadsheet into a single cell, but preserve the formatting. I want to merge the cells in column B into a single cell and preserve the line breaks and as much formatting as possible. I've attached an example spreadsheet below. For cell A1, I want to merge the B1 - B23 cells all into B1 and preserve all the line breaks and formatting. For cell A24, I want to merge the B24 - B38 cells all into B24 and preserve all line breaks and formatting and then both A24 and B24 would move to A2 and B2. I have several thousand rows to merge like this. Is this possible?
I was trying to use the concatenate formula with char(10). It was kind of working, but not quite. Probably operator error.
Any help is appreciated.
Example.xlsx
I was trying to use the concatenate formula with char(10). It was kind of working, but not quite. Probably operator error.
Any help is appreciated.
Example.xlsx
Microsoft Excel
Last Comment
Professor J
My first thought is that you are trying to do a complex text document in Excel, which is not the right application -- that would be Word. Is there some reason you are using Excel? Would it be possible to move the data to Word?
Try this, result on Sheet2.
Concatenate-keep-cell-format.xlsm
Concatenate-keep-cell-format.xlsm
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
@-Dman100
although you have accepted the question, i quote your question "preserve all the line breaks and formatting"
you did not mention just line break but formatting as well.
the UDF "Allcomments" do not bring the formatting of source cells
perhaps you did not check Ejgil Hedegaard's solution ID: 41803929 which takes care of everything including formatting.
just a thought.
although you have accepted the question, i quote your question "preserve all the line breaks and formatting"
you did not mention just line break but formatting as well.
the UDF "Allcomments" do not bring the formatting of source cells
perhaps you did not check Ejgil Hedegaard's solution ID: 41803929 which takes care of everything including formatting.
just a thought.