Re: $$Excel-Macros$$ Extract only text from alphanumeric string

2014-03-27 Thread pmyk
SImple and good suggestion. On Thursday, March 27, 2014 11:30:27 PM UTC+5:30, Rupesh Patil wrote: > > PFA, > > > > > On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow > > > wrote: > >> Hi Team, >> >> I need to extract only the text from the alphanumeric string, can you >> please help me with

Re: $$Excel-Macros$$ Extract only text from alphanumeric string

2014-03-27 Thread Rupesh Patil
PFA, On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow wrote: > Hi Team, > > I need to extract only the text from the alphanumeric string, can you > please help me with a formula. > > Sample data attached > > 12Mum159 Mum 46Kol2335 Kol 63Ch270 Ch 180Del307 De > > Regards, > > > -- > Ar

$$Excel-Macros$$ Extract only text from alphanumeric string

2014-03-27 Thread Capt. Jack Sparrow
​Hi Team, I need to extract only the text from the alphanumeric string, can you please help me with a formula. Sample data attached 12Mum159 Mum 46Kol2335 Kol 63Ch270 Ch 180Del307 De Regards, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW