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

Re: $$Excel-Macros$$ EXTRACT ONLY TEXT

2012-09-17 Thread BNS kumar
Hi, The below formula is a generalized version. Hope it works. Even the string starts with numbers, this formula works. * =IF(ISNUMBER(VALUE(LEFT(A1,LEN(A1)-SUMPRODUCT(NOT(ISERR(SEARCH({"1","2","3","4","5","6","7","8","9","0"},A1)))*{1,1,1,1,1,1,1,1,1,1},RIGHT(A1,LEN(A1)-SUMPRODUCT(NOT(ISERR

RE: $$Excel-Macros$$ EXTRACT ONLY TEXT

2012-09-17 Thread Rajan_Verma
@googlegroups.com Subject: $$Excel-Macros$$ EXTRACT ONLY TEXT Hi Friednds, Please help me to extract only text from alphanumeric word for example NT2 = NT SUB123= SUB WELC90= WELC Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ EXTRACT ONLY TEXT

2012-09-17 Thread NOORAIN ANSARI
Dear Sundar, See attached sheet, hope it will help to you. On Mon, Sep 17, 2012 at 2:47 PM, Sundarvelan N wrote: > Hi Friednds, > > Please help me to extract only text from alphanumeric word for example > > NT2 = *NT* > SUB123= *SUB* > WELC90= *WELC* > Thanks > N.Sundarvelan > 9600160150 > > -

Re: $$Excel-Macros$$ EXTRACT ONLY TEXT

2012-09-17 Thread Kuldeep Singh
Hi Sundarvelan, Kindly find the attached solved sheet. I hope it will help you. Regards, Kuldeep Singh On Mon, Sep 17, 2012 at 4:17 PM, Vabz wrote: > Dear Santosh, > > You are true but logic is set by Karan & Prince based upon requirement. > > Rgds//Vabs > > > On Monday, September 17, 2012 3:

Re: $$Excel-Macros$$ EXTRACT ONLY TEXT

2012-09-17 Thread Vabz
Dear Santosh, You are true but logic is set by Karan & Prince based upon requirement. Rgds//Vabs On Monday, September 17, 2012 3:28:56 PM UTC+5:30, santosh wrote: > > Hi Karan, > > Your formula works fine when the value starts with text.If the value > starts with a number it does't work. > > An

Re: $$Excel-Macros$$ EXTRACT ONLY TEXT

2012-09-17 Thread Sundarvelan N
Thanks prince141987 & Karan1237 Thanks N.Sundarvelan 9600160150 On Mon, Sep 17, 2012 at 3:00 PM, Karan Singh wrote: > Dear Sundar, > > Please use below formula : > > > =LEFT(A1,MIN(FIND({"0","1","2","3","4","5","6","7","8","9"},A1&"0123456789"))-1) > > Rgds > Karan Singh > > > > > On Mon, Sep

Re: $$Excel-Macros$$ EXTRACT ONLY TEXT

2012-09-17 Thread Karan Singh
Dear Sundar, Please use below formula : =LEFT(A1,MIN(FIND({"0","1","2","3","4","5","6","7","8","9"},A1&"0123456789"))-1) Rgds Karan Singh On Mon, Sep 17, 2012 at 2:47 PM, Sundarvelan N wrote: > Hi Friednds, > > Please help me to extract only text from alphanumeric word for example > > NT2

$$Excel-Macros$$ EXTRACT ONLY TEXT

2012-09-17 Thread Sundarvelan N
Hi Friednds, Please help me to extract only text from alphanumeric word for example NT2 = *NT* SUB123= *SUB* WELC90= *WELC* Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violat