Deba Please share your workbook
On Wed, Jun 27, 2012 at 2:38 PM, Deba Ranjan drdeva...@gmail.com 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
pls find attached sheet
On Wed, Jun 27, 2012 at 2:52 PM, Deba Ranjan drdeva...@gmail.com 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
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 gawlianil8...@gmail.com wrote:
pls find attached
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 gawlianil8...@gmail.com wrote:
sorry for wrong
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 drdeva...@gmail.com wrote:
Thanks Anil Ji,
its superb working. Anil Ji, Is there any option
ok ok. thats true, any thanks Anil Ji,
Thanks Regards,
*Deba Ranjan P*
On Wed, Jun 27, 2012 at 4:02 PM, Anil Gawli gawlianil8...@gmail.com 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.
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
:* 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 Punctuation
** **
pls find attached sheet
On Wed, Jun 27, 2012 at 2:52 PM, Deba