Forum Discussion
Merging Cells without losing data
- Feb 25, 2021
I agree with the suggestion above to avoid using merged cells. Typically it can be avoided by just adjusting the column width to fit the data in it, but we can't see what lies below, so you may have a reason, and it's not my place to tell you it's wrong or right. To answer your question directly, Select cell G4 to J<last row of data>. Go to the Home tab, and click the arrow next to Merge, an you should see other options. Choose Merge Across, and it will do all the cells that you have selected row by row. Also, for future reference, I suggest not posting personal information in your posts. Name email and phone numbers are probably not information you or the individuals on the spreadsheet want published on the interwebs.
<Edit>
When you merge, Excel will keep the data on the leftmost cell, so if you do this on row 2, you may lose the E-MAIL header, but as long as the email addresses are all in G you shouldn't lose any of them
Perhaps the simplest is the CONCATENATE function. So here are some examples of concatenating multiple lines into one:
Merge lines with spaces between dates: For example = CONCATENATE (B1, “”, B2, “”, B3)
Combine lines with no spaces between values: For example = CONCATENATE (A1, A2, A3)
Merge rows> separate the values with a comma: For example = CONCATENATE (A1, “,”, A2, “,”, A3)
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Thank you, this was very helpful to me NikolinoDE