Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #17  
Old 03-31-2021, 10:19 PM
macropod's Avatar
macropod macropod is offline find and replace a number that's always in a table and always adjacent to a cell with known text Windows 10 find and replace a number that's always in a table and always adjacent to a cell with known text Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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

Quote:
Originally Posted by mbcohn View Post
Would you mind providing some guidance on what this means?
Code:
.Text = "[PR][eu][bv][ils]{3}[ehno]{2}[ Ndo]{1,3}"
Basically, that's a wildcard Find expression. The:
• [PR] says to find either P or R;
• [eu] says to find either e or u;
• [bv] says to find either b or v;
• [ils]{3} says to find any 3-letter combination consisting of i, l, and/or, s;
• [ehno]{2} says to find any 2-letter combination consisting of e, h, n, and/or o
• [ Ndo]{,1 3} says to find any 1- to 3-letter combination consisting of a space, N, d, and/or, o.
Whilst the character combination possibilities are almost endless, the reality is that, given the words used in the English language, such an expression is unlikely to Find anything other than 'Revision No' or 'Published' (with or without the trailing space for the latter).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
tables, vba, vba find and replace

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace rows in a table based on bold text. OfficeAssociate99 Word VBA 2 07-26-2017 06:32 AM
Select Cell Text to paste into Find/Replace CBarry Word VBA 2 02-16-2017 04:37 AM
Increase number in cell, based on value in adjacent cell scottyb Excel 3 02-02-2017 03:51 AM
find and replace a number that's always in a table and always adjacent to a cell with known text VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color jc491 Word VBA 8 09-30-2015 06:10 AM
Word VBA Find Table Text Shading Colour and replace with another QA_Compliance_Advisor Word VBA 10 09-19-2014 08:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:51 PM.


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