Templates / Enrichment
Format personal name
Cleans a column of people's names — strips emojis, symbols, double spaces and the job titles people staple onto their LinkedIn name.
What it isEnrichment
An enrichment column. It reads a column you already have and writes a new one beside it.
InputWhat you give it
A column that already holds the value this reads.
OutputWhat comes back
| Input | First | Last |
|---|---|---|
| JANE O'CONNOR | Jane | O'Connor |
| dr. marcus reed, phd | Marcus | Reed |
| van der Berg, Anouk | Anouk | van der Berg |
Illustrative. Casing, honorifics and stray credentials — the things that make "Hi DR. SMITH, PHD," go out the door.
How it worksOne thing you decide
- Pick the source columnThe original stays as it is; the cleaned value goes in a new column beside it.
FAQQuestions people actually ask
Why bother?
A first name with a rocket emoji in it ruins an email's first line. This is the step that stops that reaching a prospect.
What does "Auto-run on new rows" do?
Runs this column by itself whenever new rows arrive — no clicking Run. It only picks up new arrivals; rows already in the table when you turn it on are left alone. It only fires while the app is open — closing it pauses everything until you reopen.
What does "Add run condition" do?
Skips rows where a condition on another column isn't met — e.g. only run if Email is empty. Skipped rows cost no actions, on both manual and auto runs.