Hi,



I need a macro for removing a dot .... in a document.

condition is not to removed a single " . " before or after followed by a word or sentence.

if a single . followed by another .. or multiple .... has to be removed a " . "completely.

doc type: ".docx" " ".rtf"

Example:

Input: macro...... output : macro

Input : macro.excel output : macro.excel

You don't need a macro for this. It can be done via Find/Replace. The real question, though, is whether you might have a series of period characters (i.e. '.') or an elipsis (i.e. '…')

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

hi,
in my document am having more than 200 tables and line items in a table will be followed by ..... and this dot ( . ) is not a fixed characters to replace manually. it is changes for every single line items in a table. some times having 9 dots , 13 dots, 15 dots, 21 dots and vice versa...

my intention if there is more than one dot then dots should be removed and if there is a only single dot then it shouldnt be removed or it remains fixed usual.

if this is automate by a macro, it will be more helpful to me....

If you want a macro solution, post a sample document that shows what your content actually shows as. The consecutive dots could be other things (spaces, ellipses or tab leaders) so we need to see what it is you want a solution to.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

As per your other thread, a single wildcard Find/Replace could be used to remove all repeated '.' characters from a document, leaving just one '.' in their place. For example:
Find = [.]{2,}
Replace = .

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi,

With reply to previous post am attaching a sample word document having .....

i want to remove the complete dots, if more than one dot (" . ") exists before and after a descriptions in a document.

If there is only one " . " it should be remains fixed and no need to change.

doc type : docx & rtf

PFA.

Is it possible through macro to automate this task...

Please do the needful and thanks in advance.

Attached Files

Example Dot.....docx (125.8 KB, 6 views)

Kindly read post #5. You do not need a macro for this.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]