I have 2 columns A and B as shown. Cell A2 has the value a, black, and cell B2 has the value b red.
Now I merge into 1 column, the column after being merged has the value ab, the color remains the same as at the beginning.
How do I do
Looking forward to the help of everyone!
Screenshot 2023-05-25 094018.pngScreenshot 2023-05-25 094203.png
Rule No 1 in Excel...Don't merge cells...
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
My boss asked me to do it, but there are too many lines. If you do it manually, it takes a lot of time. I have to do that every week, sometimes more than 2000 lines.
I don't know if there is a way to merge cells faster?
This is based on Col A & B starting in row 1
Please Login or Register to view this content.
Last edited by sintek; 06-10-2023 at 03:42 AM.
Yes, but after doing it, it can't be "undo".
Thanks
I have no idea what you are saying...
Upload a sample file and show before | after expected result
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks