--- title: "Split cell" description: "Break any column into multiple new columns — by delimiter, regex, character position, or whitespace." url: https://help.manyreach.com/en/articles/109-split-cell collection: "Enrichment tools" updated: 2026-06-24 language: en --- # Split cell Break any column into multiple new columns — by delimiter, regex, character position, or whitespace. Split cell is the Swiss army knife for unpacking columns that contain more than one piece of information. Search Engine titles, full names, addresses, comma-separated tags, URL paths — anything where you need to pull out a specific piece of structured data into its own column. The most common use: turning a Search Engine result title like `Danielle Lazier - San Francisco Real Estate Broker` into two columns — `Danielle Lazier` and `San Francisco Real Estate Broker` — so you can use each piece separately downstream. ![](https://staticfiles.gleap.io/gattachments/r84JXjlgrEOBFXwP3AwrfWhNMiAp1cYmcPqmljy0xCFV24KtTlkdCOFjM4SQjToUt84AiPPNBkM.png) ## How to set it up When you add a Split cell column, you'll see a settings panel with three sections. ![](https://staticfiles.gleap.io/gattachments/ANqcJuFsxMsrPKuw3SILIg0DIlQwKUM7UhF3x23pqB5GSriV7c82bALk5IEedHuBB8A5Xotpm29.png) ### Source column Pick the column you want to split. Manycrawl shows the first row's value as a preview, which is essential for Split cell — you need to _see_ the source content to choose the right operator and delimiter. The source column is never modified. Split cell only adds new columns next to it. ### Operator Six ways to split the cell, each suited to a different shape of data: - **Split by delimiter** — the default. Splits on a specific character or string like `-`, `,`, `|`, or `@`. Use this for delimited data: LinkedIn titles, email addresses, comma-separated lists. - **Split by regex** — same as above but uses a regular expression as the delimiter. Use this when the separator varies (multiple possible delimiters, optional whitespace, etc.). - **Extract by regex (capture groups)** — runs a regex with capture groups and pulls out each captured group as its own column. Use this when you want to extract specific patterns from messy text — phone numbers, dates, prices. - **First N characters / rest** — splits at a fixed character position. Use this for fixed-width data like product SKUs (`ABC-12345` where the first 3 characters are the category code). - **Before index / after index** — splits at the first occurrence of a specific character. Useful for splitting email addresses: everything before `@` is the local part, everything after is the domain. - **Trim whitespace** — strips leading and trailing whitespace from the column without splitting. A quick cleanup operator when you don't actually need multiple columns. ### Delimiter / Pattern / Index The second field changes based on the operator you picked. For Split by delimiter, it's the character to split on (default is `-`). For regex operators, it's the regex pattern. For First N characters, it's the number of characters. ### Output Two options for how the split result lands in your table: - **First part + rest** (default) — produces exactly two columns. The first column gets everything before the first delimiter, the second column gets everything after. Best when you only care about one of the parts. - **All parts (up to 10 columns)** — produces a column for every split section, up to 10 total. Best when the source has a known structure with multiple meaningful parts. The source column is never modified. New columns appear next to the Split cell column: the first part lives in the parent column, and any following parts appear as child columns. ## Common use case: extract names from Search Engine LinkedIn results You've used Search Engine to find LinkedIn profiles with a query like `site:linkedin.com/in/ real estate broker San Francisco`. Each result's Title field comes back shaped like: ```javascript Danielle Lazier - San Francisco Real Estate Broker Jeremy Lee - Commercial Real Estate Broker Misha Weidman - San Francisco Real Estate Broker Joe Polyak - Top 1% San Francisco Realtor Ruth Krishnan - #1 SF Realtor® | San Francisco's Top Agent ``` The name is right there, but it's mashed together with the job title. Split cell separates them in one pass. Setup: - **Source column:** `SERP → Title` - **Operator:** Split by delimiter - **Delimiter:** `-` (just a hyphen) - **Output:** First part + rest Hit Create and run. You instantly get two clean columns: Split cell (names) Part 2 (titles) ![](https://staticfiles.gleap.io/gattachments/oj4Jqyt7AL8Y5l3gargaGk2F7OcX2DEUPdEl04RUIS6CwLMRU2cndTgjXUNmS3R8AYEUZn8RVtL.png) From there, the names are ready to: - Run through **Format personal name** to strip any remaining emojis or symbols - Feed into **Find email by name** to get verified business emails - Use in **Analyze and Write** prompts for personalization This three-step pattern — Search Engine → Split cell → Format personal name → Find email by name — is the canonical LinkedIn prospecting pipeline in Manycrawl. ## Other use cases **Split email addresses.** Use `Before index / after index` with `@` as the delimiter to separate the local part (`alice`) from the domain (`acme.com`). Useful when you want to enrich the domain separately. **Unpack comma-separated lists.** A column containing `On-site, Online, Emergency service` becomes three columns when you split by `,` with All parts output. **Extract a URL path.** Split a URL by `/` with All parts to break it into protocol, domain, and path segments. **Pull a phone number out of messy text.** Use `Extract by regex (capture groups)` with a pattern like `(\+?\d[\d\s-]{8,})` to pull phone numbers out of scraped Body text. **Quick whitespace cleanup.** If you have a column with inconsistent trailing spaces, Split cell with Trim whitespace cleans it up in one pass — no other operator needed. ## Tips - **Always check the preview before running.** The first-row preview tells you exactly what character you need as the delimiter. If the LinkedIn titles use `-` (hyphen with surrounding spaces), splitting by `-` alone produces messy output with leading/trailing spaces — use Split by regex with `\s*-\s*` instead, or follow up with a Trim whitespace operator. - **First part + rest is what you want most of the time.** Even when the source has many parts, you usually only care about isolating one specific piece. Only reach for All parts when the structure is genuinely multi-part. - **Chain Split cell + Format personal name for LinkedIn data.** Split cell isolates the name; Format personal name strips any remaining emojis or symbols. Two fast columns and you have a perfect name field. - **No API key needed.** Split cell runs entirely in your browser using deterministic rules — no AI, no provider calls, no cost per row.