Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
Old 04-20-2020, 12:30 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There is plenty of code on this forum demonstrating the use of the Split function for this. Indeed, I've even provided code for you using that very function...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Style separator - doubles up on second half wernie Word 6 01-18-2016 12:31 PM
How to change footnote separator direction maamiradina Word 5 05-01-2015 09:39 PM
line separator for paragraph creieru Word 1 06-07-2012 11:11 AM
Decorative Text Separator breakwater100 Word 1 12-05-2011 10:15 PM
thousands comma separator taylormayd Excel 3 02-20-2009 03:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft