Flash Fill: patterns without formulas

Was du danach kannst

Split and rebuild text by showing Excel one worked example, and recognise when Flash Fill is the wrong tool.

Ridgeline's sales export has the rep's full name in one column. Marketing wants first and last separately, and IT wants email addresses. You could write three text formulas. You could also type one example and press one key.

Schritt 1 von 6 · 1 Punkt

You have typed one example of the pattern you want in the column beside your data. Press the shortcut that fills the rest.