| Description | Formula |
|---|---|
| Everything between brackets, i.e., all HTML code | <.*> – 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) |
