Thread: [Solved] “ . ” Separator.
View Single Post
 
Old 04-19-2020, 10:06 PM
nmkhan3010 nmkhan3010 is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2020
Posts: 23
nmkhan3010 is on a distinguished road
Default “ . ” Separator.

Hi,

I need a macro for “ . ” Separator.

Other than numbers after a “ . ” should get one single space, if already one single space is available ignore the condition.

Main objective was to get separate a string from a dot ( . ) and it should not effect on any numbers.

Ex:
1.Asdfasd ( this should be separated)
1. Asdfasd (this should be separated)

20.04.2020 (This should not be separated)
20.04.2020 (This should not be separated)

10.3651.1321 (This should not be separated)
10.3651.1321 (This should not be separated)

1.Thank you ( this should be separated)
1. Thank you (this should be separated)

Format type “.doc” “.rtf” “.docx”

Your help is highly appreciated and thanks in advance for your support..
Reply With Quote