RE: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread Priti_Verma
))*ROW(INDIRECT("1:"&LEN(C7)) with CSE Priti Verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 27 July 2012 12:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread Jayaprakash S
Excellent Master!!! was looking out the answer in formula only... so working superb !! thanks a ton to every one for your valuable efforts !! cheers JP On Fri, Jul 27, 2012 at 2:24 PM, NOORAIN ANSARI wrote: > Dear JP, > > by Formula, You can use.. > > =TRIM(RIGHT(C7,LEN(C7)-COUNT(--MID(C7,RO

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, by Formula, You can use.. =TRIM(RIGHT(C7,LEN(C7)-COUNT(--MID(C7,ROW(INDIRECT("1:"&LEN(C7))),1))) with ctrl+shfit+enter See attached sheet. On Fri, Jul 27, 2012 at 1:09 PM, NOORAIN ANSARI wrote: > Dear JP, > Please See attached sheet. > > > On Fri, Jul 27, 2012 at 1:04 PM, NOORAIN A

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread Deba Ranjan
Dear JP, See the attached, hope this too will help you for extracting text. Thanks & Regards, *Deba Ranjan P* On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI wrote: > Dear JP, > > Formula is working fine.. > Please see attached sheet. > > On Fri, Jul 27, 2012 at 12:32 PM, Jayapra

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, I got my mistake..Just i am sending you correct answers. On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI wrote: > Dear JP, > > Formula is working fine.. > Please see attached sheet. > > On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S < > bhat.jayaprak...@gmail.com> wrote: > >> Dear Expe

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, Formula is working fine.. Please see attached sheet. On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S wrote: > Dear Experts, > > Good Morning. > > I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1 > Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I >

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread Jayaprakash S
Dear Noorain, My data is in Column "C"... if i change the column in your formula then it is giving the Text with number only... Please relook in to it and help me. thank you. JP. On Fri, Jul 27, 2012 at 12:48 PM, NOORAIN ANSARI wrote: > Dear JP, > > See attached sheet. > > > On Fri, Jul 27, 2

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread अनिल नारायण गवली
Pls find attached sheet FYI Regards, Gawli Anil On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI wrote: > Dear JP, > > Please use.. > > *=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT("48:58"))),"")* > > > On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S <> wrote: > >> Dear Experts, >> >> Good Morning. >

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, See attached sheet. On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI wrote: > Dear JP, > > Please use.. > > *=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT("48:58"))),"")* > > > On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S < > bhat.jayaprak...@gmail.com> wrote: > >> Dear Experts, >> >> Good

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread NOORAIN ANSARI
Dear JP, Please use.. *=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT("48:58"))),"")* On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S wrote: > Dear Experts, > > Good Morning. > > I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1 > Uttar Pradesh, 20 Jharkhan) and without text also

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

2012-07-27 Thread अनिल नारायण गवली
Dear Bhat. Pls find Attached Sheet FYI Regards, Gawli Anil On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S <> wrote: > Dear Experts, > > Good Morning. > > I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1 > Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I >