$$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

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 lucky60...@gmail.comwrote: 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,

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 lucky...@gmail.comjavascript: wrote: Hi Team, I need to extract only the text from the alphanumeric string, can you please