Hi everyone,
My problem right now is that I have to split a cell into different columns but it's not separated by any character or any tabs. The different entries in the cell are written on different lines in the cell (like when pressing Alt+Enter to write on another line in the same cell). The cell looks like this:
AAA
BBB
CCC
DDD
I would like to be able to separate the entries into different column. How can I do this?
If I try the Text to Column function, I am only able to get the first entry, and it deletes the rest.
Thank you for your answers.
Bookmarks