View Single Post
 
Old 08-16-2021, 07:43 AM
Charles Kenyon Charles Kenyon is offline Windows 10 Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,470
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Will the numbers always have seven digits following the decimal point? Is the pattern always ##.#######?

Wildcards work on the Find function to give you multiple options. The following pattern should get you to these numbers although it may pick up others and should not be used for replace because it may not pick up the entire number.
Code:
[0-9]{1,3}.[0-9]{7}
Someone else (like Graham), better versed in use of wildcards, may come along and give you the exact pattern you need. This is a useful tool to know.

Last edited by Charles Kenyon; 08-16-2021 at 11:39 AM. Reason: added wildcard codes
Reply With Quote