Separate Alpha and numeric characters

**sivdin** · 05-05-2009, 03:18 AM

Dear all,

I need a macro to delete only the alphabets which are entered along with numbers. Ex: 300ML. BY running a macro i need to delete only the "ML" and the number 300 should remain the same.

Range is For Rows: Entire rows
For columns: F TO P

The cell values betwwen these ranges contains alphanumeric such as 20KG,300ML,200M ...etc

Hence i need a macro to delete the alpha charecters for the particular range.

Can anybody help me in this regard.

Thanks in Advance.

Alex

**DonkeyOte** · 05-05-2009, 03:27 AM

It's not really clear whether all text strings are to be altered or only those containing numbers (ie do you have strings such as "apple" which should be ignored?)... also unsure as to whether the numbers always precede the alphas... assuming the answer to both is yes then:

Please Login or Register  to view this content.

**royUK** · 05-05-2009, 03:37 AM

If your numeric parts are the first characters then you can use Val

Please Login or Register  to view this content.

**sivdin** · 05-05-2009, 05:46 AM

Thank you very much .Ur understanding was right according to what i explained.
I will try this code.
Also,Thanks roy for ur code.

**mridzuani** · 05-05-2009, 06:27 AM

I used this function although this only separate the numbers

Please Login or Register  to view this content.

**royUK** · 05-05-2009, 07:01 AM

Your Function doesn't need to use Val and can easily be adapted to extract letters

Please Login or Register  to view this content.

**sivdin** · 05-06-2009, 06:26 AM

Thank you very much everyone!!!!!

**Balamani** · 08-09-2013, 02:45 AM

In a column i had alphanumeric and other text but i need only alphanumeric value only to can u help me
ex: HL5340D Toner Cartridge 3K TN3230
i want [HL5340D] this value in to another cell

**Fotis1991** · 08-09-2013, 02:50 AM

Welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.