The SEMTools for Excel add-in offers a menu in the EXTRACT group that can help you extract specific character sets linked by common attributes, when just finding symbols in Excel is not enough and you need to extract them to make further decisions.
With this add-in menu, you can:
- Extract Latin characters, numbers
- Extract any letters and numbers (in other words, remove punctuation and other characters from the cells)
- Extract the numbers from the text
- Extract characters by typeface, for example, extract bold, italic, or underlined characters
- Extract certain sequences of characters, such as:
- The first N characters in the cell
- The last N characters in the cell
- The characters before/after the first occurrence of the pattern
- The characters before/after the last occurrence of the pattern
- Characters using regular expressions in Excel, including ready-made patterns such as domains from full URLs and other strings containing URLs, e-mail, and dates.
[картинка]
Other text operations with characters
In addition to character extraction, the exact opposite operation may be necessary – removing characters. Also, once you are familiar with the extracted data, you may find the section about changing symbols in Excel useful, such as changing the case of letters.
But first of all, before any such action, it is always useful to first find the symbols that you have defined. After all, if you don’t have them, you don’t need to do anything else :)