I have a problem with a formula in Excel, I am trying to copy a text from one spreadsheet to another. I have the code that copies it but when copying ignores the line breaks, does anyone know how I could fix this? thank you.
I have a problem with a formula in Excel, I am trying to copy a text from one spreadsheet to another. I have the code that copies it but when copying ignores the line breaks, does anyone know how I could fix this? thank you.
I do not know what your code is but in your formula all you do is call the value of cell A1 on sheet main1 . Therefore, the only thing you have is the text, without its format. As @tecnologer said in his commentary, it is a question of the format of the target cell.
You have 2 options:
It's the only thing you have to do. Test and tell us.