# how can i move my data from 1 column to another

#### akash121

##### Board Regular
Hello,

I new in VBA
can anyone suggest me how can i move my data from 1 column to another.

My column name is processor(is 5th column in excel) data starting from 7th Row having name and number together like akash21, deepak43, ravi12, Naveen13, and so on till 1156 row how can i move "only numbers" from 5th column to create new column beside it having their respective number.

Thank you

Akash

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### Rick Rothstein

##### MrExcel MVP
My column name is processor(is 5th column in excel) data starting from 7th Row having name and number together like akash21, deepak43, ravi12, Naveen13, and so on till 1156 row how can i move "only numbers" from 5th column to create new column beside it having their respective number.
Are your numbers always 2 digits long (as you have shown in all of your examples)?

#### akash121

##### Board Regular
No, have few 1 digit number too inbetween.

#### Rick Rothstein

##### MrExcel MVP
No, have few 1 digit number too inbetween.
Okay, put this formula in F7 and copy it down...

=MID(E7,MIN(FIND({0,1,2,3,4,5,6,7,8,9},E7&"0123456789")),9)

#### akash121

##### Board Regular
Thanks Rick,
That works
but can we make some coding in VBA for that in case data is large ?

#### Rick Rothstein

##### MrExcel MVP
Thanks Rick,
That works
but can we make some coding in VBA for that in case data is large ?
The formulas will be more efficient than VBA code would be; but if that is what you want, you will need to tell us how you want the code to function... do you want a macro that you must manually run in order to create the list or will you need the cells to be able to update in real time as values are entered into Column E (like a formula does)?

#### akash121

##### Board Regular
i would like excel to update data as i enter values in column E.

#### mirabeau

##### Banned user
i would like excel to update data as i enter values in column E.
Why not just use VBA to fill down Rick's formula as far as you like, or get the code itself to determine how far down if that's what you want ...
Code:
``````Sub numbers()

Range("F7").Resize(1000) = "=MID(E7,MIN(FIND({0,1,2,3,4,5,6,7,8,9},E7&""0123456789"")),9)"

End Sub``````

#### akash121

##### Board Regular
Awesome that works perfect thanks Mirabeau and rick for help

Replies
1
Views
512
Replies
6
Views
187
Replies
0
Views
137
Replies
7
Views
237
Replies
0
Views
260

1,195,749
Messages
6,011,437
Members
441,614
Latest member
TiaGtz

### 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.

### Which adblocker are you using?

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

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