Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-06-2020, 06:45 PM
Mr J Mr J is offline Help creating a macro to identify values that have letters and numbers. Windows 10 Help creating a macro to identify values that have letters and numbers. Office 2016
Novice
Help creating a macro to identify values that have letters and numbers.
 
Join Date: Aug 2020
Location: California, US
Posts: 15
Mr J is on a distinguished road
Default

Technically all the examples are hits because the documents I'm reviewing have references to equipment but every piece of equipment has a different abbreviation based on type (e.g. Valve=V, Motor=MTR....) and different numbers based on location and how many there are in the field (e.g. Area 82, Valve#123 = 82V123 OR Motor#12=MTR12). I know it's kind of vague but some could be 4 characters (with 2 letters and 2 numbers) and others can be 10 characters (with any combination of numbers and letters). Again I know it's not a simple request so I will take anything I can get.

Honestly even if I got the macro to highlight everything, I would still go through the document to confirm that what it identified should be highlighted. That is why the extra part in my request would help me a little more, because if I had a separate list I could review what was highlighted and not have to scroll through the pages. Then I could verify based on that list and if that list is in a different location and I have confirmed everything, I can just delete the list and save the original file with the highlighted equipment numbers.

Please let me know if you have any more questions or if I need to clarify something.

Also I haven't looked at the other forum you mentioned yet but I will definitely check it out and see if I can tweak it to fit my needs. Thank you!
Reply With Quote
 

Tags
numeric, phonetic, word macros



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help creating a macro to identify values that have letters and numbers. Creating your own Section Headings using Numbers and letters and linking to the TOC rehahm Word 4 10-07-2015 10:20 AM
Help creating a macro to identify values that have letters and numbers. Creating a TOC with sequential letters instead of page numbers at the right margin shansen Word 1 03-11-2014 12:43 PM
Look up cell values with mixed number and letters Cardinal2 Excel 1 02-10-2013 01:40 AM
Help creating a macro to identify values that have letters and numbers. Captions mixing letters and numbers trew Word 7 11-21-2012 12:54 AM
Help creating a macro to identify values that have letters and numbers. Creating TOC with letters and numbers tanababa Word 1 04-28-2011 01:35 AM

Other Forums: Access Forums

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