Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-25-2019, 12:25 PM
KBeMe KBeMe is offline Extracting Numbers from String Windows 10 Extracting Numbers from String Office 2016
Novice
Extracting Numbers from String
 
Join Date: Sep 2019
Posts: 1
KBeMe is on a distinguished road
Default Extracting Numbers from String

I have a User Form where the user enters information that populates a document using Private Sub cmdOK_Click(). From one of the Text Fields that the user inputs data I need to extract the numbers that are entered in the format of ##-#### stripping any other text that is entered and I then I want to be able to do a




ActiveDocument.Bookmarks("CaseNum1").Select
Selection.TypeText


to place the number minus any other characters into the document. All documentation I can find to do something like this is for Excel and does not work in Private Sub cmdOK_Click().
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help to extracting text from text string Haha88 Excel 3 02-13-2019 05:47 AM
Help with Formula to extracting text from text string Haha88 Excel 7 01-13-2019 01:33 AM
Extracting Numbers from String Help with Formula to extracting text from text string Haha88 Excel 9 02-05-2018 01:04 AM
How to extract only numbers from a STRING? Learner7 Excel 3 07-02-2013 06:25 AM
Extracting Numbers from String Extracting a phone number from a string that contains text and numbers. hommi16 Excel 2 06-05-2013 09:19 PM

Other Forums: Access Forums

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