Forum Discussion
parsing the text
Hi, I am interested in how to convert text that is grouped in one cell (with line break "alt+return") into each cell individually. And vice versa. Please see attached picture.
Hi Matej,
Sorry about that!
This is because of the conflict between data types.
The records in cells A5 and A6 are actual numbers but the rest are texts because they contain some line breaks and forward slashes.
Anyway, I've updated the query to take into account this issue and convert all the records to texts from the beginning.
PERFECT!!
Thank you!!