Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

d try using the formula provided for finding the numbers only, then > use that result with the SUBSTITUTE function substituting the numbers with > "" > Regards - Dave. > > > Date: Wed, 31 Mar 2010 11:03:55 +0530 > Subject: Re: $$Excel-Macros$$ Tip of The day:Extract Number

RE: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

Hi, You could try using the formula provided for finding the numbers only, then use that result with the SUBSTITUTE function substituting the numbers with "" Regards - Dave. Date: Wed, 31 Mar 2010 11:03:55 +0530 Subject: Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Al

$$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

Dear All if there is a coloum containg mix of nos and alphabets like ram12 moh12345an 132shyam we need only alphabets what can we do like ram mohan shyam Here we can seprate only nos. but what can we do if we want alphabets sepreately. Help in this query. Thanks in advance Regards LKModi

Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

Dear All if there is a coloum containg mix of nos and alphabets like ram12 moh12345an 132shyam we need only alphabets what can we do like ram mohan shyam Here we can seprate only nos. but what can we do if we want alphabets sepreately. Help in this query. Thanks in advance Regards LKModi

$$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

Dear All, Attached is the macro to extracting the numeric value from alphanumeric string. -- Thanks Regards Shyam Software Engineer '''