Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-28-2021, 01:14 AM
falcios falcios is offline Find and Replace and add colon and space Windows 7 64bit Find and Replace and add colon and space Office 2019
Advanced Beginner
Find and Replace and add colon and space
 
Join Date: Aug 2019
Posts: 48
falcios is on a distinguished road
Default Find and Replace and add colon and space

Hello



I have the following dates for example:

7/1/21
7/2/21
7/3/21

I would like to append a colon and a space after each date. No space between the date and the colon. The space is after the colon.
7/1/21:
7/2/21:
7/3/21:

Can you tell me please how to go about it?

Thanks in advance.
Reply With Quote
  #2  
Old 07-28-2021, 04:28 AM
Guessed's Avatar
Guessed Guessed is offline Find and Replace and add colon and space Windows 10 Find and Replace and add colon and space Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Find: ^p
Replace with: :space^p
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 07-28-2021, 04:38 AM
falcios falcios is offline Find and Replace and add colon and space Windows 7 64bit Find and Replace and add colon and space Office 2019
Advanced Beginner
Find and Replace and add colon and space
 
Join Date: Aug 2019
Posts: 48
falcios is on a distinguished road
Default

Thanks so much Guessed, you're a pro. It worked great.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace and add colon and space Using find and replace to insert an extra space after full stops Johanna Word 33 03-07-2020 01:43 PM
Macro for Find/replace to remove space before Hard Return AlfredStreich Word VBA 4 01-23-2020 03:59 PM
Find and Replace and add colon and space Code to find numerical string + space throughout document & replace them with Comma Robert Kay Word VBA 6 02-21-2018 04:41 PM
Find and Replace and add colon and space Find and Replace with space cheech1981 Word 3 03-29-2017 02:33 PM
Find and Replace and add colon and space is it possibe to capitalize every letter after a "colon space" angeltread Word VBA 4 01-17-2011 03:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:40 AM.


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