Cells are pasted with extra empty line

I am building an automation tool that pastes data in Excel.

For some reason it always puts an extra line after the data. This is not a huge problem until the import is supposed to be in numbers.

Due to the extra line I get a lot of #VALUE! when I try to make calculation with the imported data.


Is there a way with a formula, for example the same value in A2 as in A1, but then A2 without the extra line so I have numbers where I can work with?

Thank you!

In A2 you could try using =TRIM(A1), but probably best to fix the problem at the source rather than fix it afterward.

BSB

I tried that, but I think TRIM only changes it visually and I'm still not able to make calculations with the new Trimmed cell.

Thank you for your time!

TRIM will remove extra / trailing spaces and things like that.

Could be formatted at text. There are ways to fix that.

Paste a sample workbook so we can take a better look.

BSB

Thanks,

I included a sample workbook.

Try CLEAN in place of TRIM

BSB