Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2021, 11:37 PM
Cray_Z Cray_Z is offline Macro to extract CCIs as separate entries when part of a text string Windows 10 Macro to extract CCIs as separate entries when part of a text string Office 2016
Novice
Macro to extract CCIs as separate entries when part of a text string
 
Join Date: Sep 2014
Posts: 16
Cray_Z is on a distinguished road
Default

Greg,
Thanks for the quick response. It is working with one small flaw. It is capturing other numbers that are not enclosed in "(CCI:" and ")". If I had to guess, which I have to or I wouldn't need your help, I think it is identifying number (CCI: 000123) and stripping off the on the first pass "(CCI:" and ")" leaving 000123 in the array. On the second pass it finds the "naked" 000123 number and captures that along with the page number. Is there any way to resolve this?
Also, I realize that I may be asking for too much but I have several entries that appear as (CCI: 000123-000125). Is there a method to have that captured as:


000123
000124
000125
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to extract CCIs as separate entries when part of a text string Extract Bold text from string one4youman Word VBA 8 04-18-2019 12:31 AM
Formula to Extract text from a text string Haha88 Excel 2 11-14-2017 01:32 AM
Macro to extract CCIs as separate entries when part of a text string Extract text from a text string Haha88 Excel 8 02-13-2017 05:06 PM
Extract numbers from a text string aleale97 Excel 4 02-10-2011 10:33 AM
Extract from String using Wildcard whousedmy Word 0 05-21-2009 01:35 AM

Other Forums: Access Forums

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


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