That’s probably why they’ve not been included into the Unicode standard.
#REFERENCE CARD FOR MICROSOFT WORD SYMBOLS CODE#
There’s an ISO standard (if you’re keeping score, ISO 3758:2012 “Textiles - Care labelling code using symbols”) however the symbols are copyright in various countries. OutputPattern = outReplaceRegexObj.Replace(outputPattern, inputMatches(0).Unlike many other common symbols, laundry care icons aren’t in the Unicode specification along with letters, numbers, currency, musical notes and all manner of other stuff. Largest allowed is $" & inputMatches(0).SubMatches.Count & "." If replaceNumber > inputMatches(0).SubMatches.Count Then OutputPattern = outReplaceRegexObj.Replace(outputPattern, inputMatches(0).Value) OutReplaceRegexObj.Pattern = "\$" & replaceNumber ReplaceNumber = replaceMatch.SubMatches(0) Set replaceMatches = outputRegexObj.Execute(outputPattern) Set inputMatches = inputRegexObj.Execute(strInput) In the big text window in the middle insert the following: Function regex(strInput As String, matchPattern As String, Optional ByVal outputPattern As String = "$0") As Variantĭim inputRegexObj As New VBScript_RegExp_55.RegExp, outputRegexObj As New VBScript_RegExp_55.RegExp, outReplaceRegexObj As New VBScript_RegExp_55.RegExpĭim inputMatches As Object, replaceMatches As Object, replaceMatch As Object naming the Module Regex and the function regex causes #NAME! errors). If you give your module a different name make sure the Module does not have the same name as the UDF below (e.g. Find Microsoft VBScript Regular Expressions 5.5 in the list and tick the checkbox next to it.Ĭlick on Insert Module.Click on Tools -> References (please excuse the german screenshot).Add VBA reference to the Regular Expressions library (shamelessly copied from Portland Runners++ answer):.In Excel in a Macro enabled file ('.xlsm') push ALT+F11 to open the Microsoft Visual Basic for Applications Editor.They have some good additional info there!): To use this UDF do the following (roughly based on this Microsoft page. To take apart a combined string in a single cell into its components in multiple cells: =regex("Peter Gordon: 47", "^(.+): (.+), (\d+)$", "$" & 1) Defaults to $0.Įxtracting an email address: =regex("Peter Gordon: 47", Gordon: 47", "$0") $0 is the entire match, $1 and up correspond to the respective match groups in the regular expression. A format string specifying how the result should look.A text to use the regular expression on.It more or less directly exposes regular expression functionality as an excel function. To make use of regular expressions directly in Excel formulas the following UDF (user defined function) can be of help.
![reference card for microsoft word symbols reference card for microsoft word symbols](https://support.content.office.net/en-us/media/9e49fa07-5b0d-4277-a371-31b8b01c8ceb.png)
\ Exact non-word character except any single alpha followed by any single digit
![reference card for microsoft word symbols reference card for microsoft word symbols](https://i.gr-assets.com/images/S/compressed.photo.goodreads.com/books/1395283823l/10431877.jpg)
![reference card for microsoft word symbols reference card for microsoft word symbols](https://www.wisdomjobs.com/userfiles/symbol_button.jpg)
Single alpha, single digit, 0 to 3 alpha charactersĪ1aaa * Single alpha, single digit, followed by any number of alpha characters () Groups different matches for return purposes.
![reference card for microsoft word symbols reference card for microsoft word symbols](http://www.hardware-depot-online.com/wp-content/uploads/2019/10/Word-Symbols-Library.jpg)
matches any single lower case letter of the alphabet. matches a single letter which can be a, b or c Match exactly one of the objects inside these brackets. a-z matches an lower case letters from a to z