Is this even possible...all the text is in one cell (A1). So cell A1 contains 5,932 characters including spaces, hyphens, forward slashes and numbers. Each entry contains 12 spaces. I'd like to put each entry into a separate row with one entry per cell. Each entry begins after the 12th space. Each entry varies randomly in length from 32 characters up to 38. The entry includes a date followed by six numbers.
Example ("03/09/2005 3 - 6 - 23 - 24 - 31 - 39 04/23/2006 11 - 18 - 29 - 37 - 39 - 42 12/31/1989 9 - 14 - 20 - 34 - 36 - 37 09/18/2006 12 - 14 - 18 - 29 - 30 - 41") and so forth. Is this even possible? what are the commands to do this? Thanks, Eddie.