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
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
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
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
@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
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
>
> -
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:
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
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
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
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
11 matches
Mail list logo