Hi,
I tried searching split text and text to columns, but didn't really find the answer, so I hope I'm asking something original and not something that's been explained a thousand times
I have a column of cells where each cell is a textual description of upto 60 to 80 characters. I need to split these single cells into multiple cells with a max length of 20 characters(5 cells max). The extra need and the reason that fixed length of text to columns didn't work for me is that the split must be on a word boundary. So for example:
A1 = This is a test of the emergency broadcast system
would give
B1 = This is a test of
C1 = the emergency
D1 = broadcast system
It'd be great if leading spaces would be eliminated on the new cell (but not necessary). It doesn't need to be an auto macro as this is more or less a one time deal of several hundred records.
Any suggestions?
Bookmarks