Hi,
hi have a cell with this info:
route xxx yyyy zzz 50124
I need to divide it in this way:
route
xxx yyy zzz
50124
Of course I have many line with this info.
Can someone sudgest me a macro to made that?
TIA
Renato
renareto,
Welcome to the forum!
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi
How do you want to display the data after the split? Do you want the split data on the same sheet or some other sheet?
Regards...
Hi,
Thank you to all, I attach a file with 2 row. On column A, the cell with all data. On column from C to G, the divided data on cell.
Hope this could clarify.
Renato
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks