good day, i’m new user of this forum.
I have a problem with the “canc” spreadsheets.
After copying a text file with windows end-of-line character in UTF 8-BOM format and after pasting it all in a column, I realize that part of the pasted text does not respect the original layout found in the txt file, while the remaining part is pasted in a row by cell. Just as I expected.
Someone can tell me why or how to resolve the situation.
thanks to those who can answer me
We don’t know neither the original data nor how it looks after the paste.
Could you attach two such short sample files to your question?