Text To Columns (vertically Stacked)Jul 22, 2009
Had a quick browse through the forums for an answer but as it is quite hard to describe i cant quite find the answer.
Basically I need to split some cells but they have stacked text in them i.e
Cell a1 shows:
part 77777 x 20
Cell b1 shows:
3x 4481211111 & 5 ea g8373
When i run the text to columns function i only get the first line of the data, i could ideally like to split the data by spaces and/ or line breaks.