Copy Numbers in Visual Basic (with a line break)

P

pecsenye

New Member
Joined
Jan 17, 2023
Messages
12
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!

exc2.png
 
Sort by date Sort by votes
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.
 
Upvote 0

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
You must log in or register to reply here.

Similar threads

B
  • Solved
VBA to read 1 line at a time from 2 CSVs and write them sequentially to the active workbook
Replies
8
Views
173
BakerSteve
B
C
  • Question
VBA copy paste currentRegion historically to another worksheet
Replies
5
Views
336
Alex Blakenburg
A
M
  • Question
Sorting part numbers based on ascending order and also putting "a" part numbers at top
Replies
4
Views
176
myall_blues
myall_blues
N
  • Question
Match and lookup combined
Replies
4
Views
244
Glenn Kennedy
G
T
  • Question
Multiple filters on filtered list
Replies
1
Views
332
Cubist
Cubist

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top