Copy Numbers in Visual Basic (with a line break)

[pecsenye]

Hello everyone,
I would like to solve the following in Visual Basic: In column A, there are two numbers one below the other (with a line break). I want to create a copy of them. Only the top number should be in column C, and only the bottom number should be in column D. It's IMPORTANT that the numbers can have different lengths (for example, 2, 31, 153, etc.) and they are not always the same length.
Thanks for helping!

 

[jolivanes]

Thanks for letting us know and good luck.
For the future, it is nice to know which excel version you're using, update your profile as suggested previously, and don't quote unnecessarily, which is most times the case.