Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2019, 01:07 PM
CrossReach CrossReach is offline What wild card set up would separate a colon followed by letters but not by numbers? Windows 10 What wild card set up would separate a colon followed by letters but not by numbers? Office 2019
Advanced Beginner
What wild card set up would separate a colon followed by letters but not by numbers?
 
Join Date: Jun 2015
Location: In my head
Posts: 70
CrossReach is on a distinguished road
Default What wild card set up would separate a colon followed by letters but not by numbers?

Example:



We answer:By grace, through Jesus Christ (Rom. 5:2),

Last edited by CrossReach; 11-26-2019 at 01:08 PM. Reason: Was converting :D into a smiley face
Reply With Quote
  #2  
Old 11-26-2019, 02:13 PM
macropod's Avatar
macropod macropod is online now What wild card set up would separate a colon followed by letters but not by numbers? Windows 7 64bit What wild card set up would separate a colon followed by letters but not by numbers? 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

Try a wildcard Find/Replace with:
Code:
Find = (\:)([A-Za-z])
Replace = \1 \2
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-26-2019, 02:45 PM
CrossReach CrossReach is offline What wild card set up would separate a colon followed by letters but not by numbers? Windows 10 What wild card set up would separate a colon followed by letters but not by numbers? Office 2019
Advanced Beginner
What wild card set up would separate a colon followed by letters but not by numbers?
 
Join Date: Jun 2015
Location: In my head
Posts: 70
CrossReach is on a distinguished road
Default

That worked great thanks. And if wanted to remove the colons in between letters rather than separate them. Would that be possible?
Reply With Quote
  #4  
Old 11-26-2019, 04:31 PM
macropod's Avatar
macropod macropod is online now What wild card set up would separate a colon followed by letters but not by numbers? Windows 7 64bit What wild card set up would separate a colon followed by letters but not by numbers? 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

Simply omit the \1.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
What wild card set up would separate a colon followed by letters but not by numbers? Need Wild Card for Deleting Square Brackets with Differing Numbers inside CrossReach Word 6 11-26-2019 01:02 PM
What wild card set up would separate a colon followed by letters but not by numbers? Wild card confusion Ulodesk Word 4 08-23-2018 06:06 AM
Wild Card Problem (Word 2007) qubie Word VBA 5 10-19-2017 06:19 AM
How to use wild card in VBA for Advance Filter? LearnerExcel Excel Programming 1 10-09-2017 12:27 AM
Wild card to highlight capitalised terms? bertietheblue Word 2 02-08-2013 04:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:49 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