To convert numbers to alphbets

[KK1234]

Hi,
I am looking for VB code to convert numbers to alphabets.
I have in column A combination of numbers and alphabets ( e.g. 12H3T56)
I want column B to automatically convert only numbers to alphabets ignoring ant alphabets in it ( 12356) as it has ignored HT.
Is it possible
Many thanks

[JieJenn]

Maybe UDF

Please Login or Register  to view this content.

[KK1234]

Hi,
Thanks a lot . This works great to extract the numbers .
Secondly now if I want to relate this number to a name in column C ( e.g. 12356 = Albert). How do I do that?
Regards

[JieJenn]

Not quiet sure I understand your question #2

[KK1234]

Hi
If I allocate a particular person a number say in this case 12356=Albert, I want e.g. 'Albert' appear in column C when Column B has 12356.

Kind regards

[JieJenn]

Use vlookup or Match/Index function.

[KK1234]

Hi
Is there a VB code for this ... I dont know how it can be done
Regards

[JieJenn]

Why do you want use VBA it can be done with a simple formula? Plus, it is hard to modify if you use VBA to replace formula in this case.

[KK1234]

OK Sir...
What will be the formula...
Sorry basic question

[JieJenn]

=Vlookup(12356, table reference, 2, 0)

[KK1234]

Thanks.
That is Great.
It will solve my issue.

Sometimes the answer lies in simple solutions than looking for complex ones.
Thanks again
Regards