I'm trying to help someone in the office with the following problem. He has the following data in an Excel file:
C1 = Column 1
C2 = Column 2
He wants to merge Column A & B into one cell. He has to manually merge each individual row by selecting the two cells, go to Format, Cells, Alignment, select Merge Cells and click OK. It does the job, but he has to do it every time and he works with that file most of the day.
When he tries to merge all the rows he gets the following message:
"The selection contains multiple data values. Merging into one cell will keep the upper-left most data only."
Is there a way around this??? I tried recording a Macro and use a shortcut key of CTRL + M. When I hit CTRL+M it does only the cell that I created the Macro. Is there a way to create a Macro that does several rows and when I hit the Shortcut Key do all them.
I hope I was clear…