Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread ashish koul
--- >> >> >> -------------- >> *From:* NOORAIN ANSARI >> *To:* excel-macros@googlegroups.com >> *Sent:* Tue, July 31, 2012 10:25:13 AM >> >> *Subject:* Re: $$Excel-Macros$$ Remove Extrict sign & replce by L >

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread Chandra Shekar
>> >> >> -------------- >> *From:* NOORAIN ANSARI >> *To:* excel-macros@googlegroups.com >> *Sent:* Tue, July 31, 2012 10:25:13 AM >> >> *Subject:* Re: $$Excel-Macros$$ Remove Extrict sign & replce

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread NOORAIN ANSARI
ple you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* NOORAIN ANSARI > *To:* excel-macros@googlegroups.com > *Sent:* Tue, July 31, 2012 10:25:13 AM > > *Subject:* Re: $$Excel-Macros$$ Remove Extrict

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread Paul Schreiner
, To all the people you can, As long as ever you can.” - John Wesley - From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Tue, July 31, 2012 10:25:13 AM Subject: Re: $$Excel-Macros$$ Remove Extrict sign & replc

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread NOORAIN ANSARI
Dear Amit, If you want output in same column, you can use Ctrl+H (Find and Replace) On Tue, Jul 31, 2012 at 7:09 PM, Amit Desai (MERU) wrote: > Dear Friends, > > ** ** > > Please note that I would like to have a formula that would remove * sign > from the text & will replace it by L. Foll

RE: $$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread Amit Desai (MERU)
Thanks a lot Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: 31 July 2012 19:30 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Remove Extrict sign & replce by L Hi, Please Use This. =SUBSTI

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread Kuldeep Singh
Hi, Please Use This. =SUBSTITUTE(A1,"*","L",1) =SUBSTITUTE(A2,CHAR(42),"L") Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 31, 2012 at

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread Paul Schreiner
the people you can, As long as ever you can.” - John Wesley - From: Amit Desai (MERU) To: excel-macros@googlegroups.com Sent: Tue, July 31, 2012 9:39:48 AM Subject: $$Excel-Macros$$ Remove Extrict sign & replce by L

Re: $$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread dguillett1
Have a look in the help index for SUBSTITUTE Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Amit Desai (MERU) Sent: Tuesday, July 31, 2012 8:39 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Remove Extrict sign & replce by L Dear Fri

$$Excel-Macros$$ Remove Extrict sign & replce by L

2012-07-31 Thread Amit Desai (MERU)
Dear Friends, Please note that I would like to have a formula that would remove * sign from the text & will replace it by L. Following is the sample data. Please help. Code Number Result needed 1234* 1234L 12456* 12456L 12appolo** 12appoloLL Best Regards, Amit __