Positive lookahead

regex

\w+(?=:)

Explanation

Matches the word before a colon without including the colon.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Lookarounds

Require text not to follow the current position.

Open In sheetregexsame section

Require text to precede the current position.

Open In sheetregexsame section

Require text not to precede the current position.

Open In sheetregexsame section

Match any text until a stopper without over-consuming.

Open In sheetregexsame section

Match only at the beginning of the input.

Match one ASCII digit character.