I have a data sheet , the column C has a series of data description with numbers and text which are all merge in one cell.
there are 7 headers after column C , my goal to split each numbers and text to their respective headers.
The expected results are in yellow as per test sheet
Do you really need a macro for this? It can be done easily with the text to columns feature using the comma as a delimiter. If you must have a macro, record the text to columns procedure.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for advise , Have a try
Thank you worked as per your advise
Last edited by JEAN1972; 10-22-2017 at 09:36 AM.
Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks