Thread: Dot seperator
View Single Post
 
Old 07-19-2021, 12:38 PM
ranjan ranjan is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: May 2021
Posts: 80
ranjan is on a distinguished road
Default Dot seperator

Hi,

I need to Seperate a text from number by single or double space.

It should be seperate only when number having a immediate text with a . (Dot only) between the number and text.

It should not seperate on a numbers only (EX: 1.362.31)

Example:

Input : 1.aasdfasdfa
Output : 1.aasdfasdfa (Space is there after 1. )

Input: 1.3671.351
Output: Input: 1.3671.351 (No changes)

Input: 2.sdfasdfssd
Output: 2.sdfasdfssd (Space is there after 2. )

Is this automated by a macro or using wildcard find and replace.

Your help is highly appreciated....
Attached Files
File Type: docx test.docx (58.3 KB, 9 views)
Reply With Quote