<div>
Hi Terry, thanks. What would match one or more spaces?
</div>


<div>
\s+ would match one or more spaces
</div>


<div>
<div class="content wysiwyg-content">
Right now I have a very simple regex pattern of : .Pattern = &quot;\d[A-M]+&quot; I haven't used regex for about 3 years and i can't remember how to write it. I might have one or two other simple questions as well.<br />
<br />
Thanks!<br />
John
</div>
</div>


Right now I have a very simple regex pattern of : .Pattern = "\d[A-M]+" I haven't used regex for about 3 years and i can't remember how to write it. I might have one or two other simple questions as well.

Thanks!
John

Regex that will specify space or no  space

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.