how can i move my data from 1 column to another

[akash121]

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

 

[Rick Rothstein]

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]

No, have few 1 digit number too inbetween.

 

[Rick Rothstein]

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]

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

 

[Rick Rothstein]

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]

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

 

[mirabeau]

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

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]

Awesome that works perfect thanks Mirabeau and rick for help