RE: $$Excel-Macros$$ Extract only from number from a text string

@googlegroups.com Cc: Kal xcel Subject: Re: $$Excel-Macros$$ Extract only from number from a text string Dear Kalyan.. Please see attached sheet..I think your problem has been soloved. Thanks, Noorain On Mon, Aug 23, 2010 at 3:36 PM, Kal xcel wrote: Dear Experts, I need a help. I

Re: $$Excel-Macros$$ Extract only from number from a text string

Dear Kalyan.. Please see attached sheet..I think your problem has been soloved. Thanks, Noorain On Mon, Aug 23, 2010 at 3:36 PM, Kal xcel wrote: > Dear Experts, > > I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits > Instant Fairness Fruit Bleach 14gm), all strings are

RE: $$Excel-Macros$$ Extract only from number from a text string

Hi, If your sample data is really representitive of ALL your data - ie, the numeric portion is always at the end of the string - then the attached should do what you need. Regards - Dave. Date: Mon, 23 Aug 2010 15:36:04 +0530 Subject: $$Excel-Macros$$ Extract only from number from a text

$$Excel-Macros$$ Extract only from number from a text string

Dear Experts, I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to extract only Numeric part (like14gm) from that string. File is attached Thanks in advance Kalyan -- ---