---
>>
>>
>> --------------
>> *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
>
>>
>>
>> --------------
>> *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
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
,
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
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
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
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
Are you wanting a formula? or VBA solution?
You can use this formula:
=SUBSTITUTE(A1,CHAR(42),"L")
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you
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 Friends,
