ks & Regards,
*Deba Ranjan P*
On Wed, Jun 27, 2012 at 6:35 PM, Rajan_Verma wrote:
> I think find and replace is best approach..
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:
I think find and replace is best approach..
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Gawli
Sent: 27 June 2012 3:15
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Remove
ok ok. thats true, any thanks Anil Ji,
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 27, 2012 at 4:02 PM, Anil Gawli wrote:
> it is possible but how u hold the values and replace it with others, for
> that u have to save the value as temp and then replace it.
>
> Regards,
> Gawli Anil
it is possible but how u hold the values and replace it with others, for
that u have to save the value as temp and then replace it.
Regards,
Gawli Anil
On Wed, Jun 27, 2012 at 3:43 PM, Deba Ranjan wrote:
> Thanks Anil Ji,
>
> its superb working. Anil Ji, Is there any option for removing all th
Thanks Anil Ji,
its superb working. Anil Ji, Is there any option for removing all the
punctuation mark at a time with code and without userform help ?
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 27, 2012 at 3:36 PM, Anil Gawli wrote:
> sorry for wrong attachment
> just see this att
Anil Ji,
That is working fine , Thanks..
Ok is there any coding for direct remove without user form.
--- i mean writing coding and run.
Thanks again.
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jun 27, 2012 at 3:15 PM, Anil Gawli wrote:
> pls find attached sheet
>
>
> On Wed, Jun
pls find attached sheet
On Wed, Jun 27, 2012 at 2:52 PM, Deba Ranjan wrote:
> Sir,
>
> PFAand there are lots of punctuation which need to be clean.
>
> For cleaning and trimming the sheets i have used the code below mention
> and it is fine working:-
>
>
> Sub TrimCleanCells()
> Dim Rng
Deba Please share your workbook
On Wed, Jun 27, 2012 at 2:38 PM, Deba Ranjan wrote:
> Dear experts,
>
>
> Is there any VBA code to remove punctuation in a sheets ?
>
> -- i am doing it manually by ctr + H (replacing the desire punctuation
> with "") and it takes many times to remove huge dat
