Excel Cheat Sheet
| Description | Formula |
|---|---|
| Match simple angle-bracket tags without consuming text between successive tags. This regex is not a general HTML parser. | <[^>]*> - screenshot by link |
| Replace line break character CHAR(10) inside cell with <br> |
=SUBSTITUTE(A1;CHAR(10);"<br/>") |
| Everything after space | =MID(A1;FIND(" ";A1)+1;32000) |
| Everything before space | =MID(A1;1;FIND(" ";A1)-1) |
| Search cell content in range of cells | =COUNTIF($A$1:$A$99987;B1) |
![<[^>]*>](/wp-content/uploads/2026/10/libreoffice-regex-settings.webp){kind=link}