ConditionalVisibility

new-products-promo

split-text-excel-image01

split-text-excel-image02

split-text-excel-image03

split-text-excel-image04

split-text-excel-image05

split-text-excel-image06

App tips

automate-spreadsheets-00-hero

Formatter by Zapier

If you work with data that needs to be split—like separating first and last names—here's how to split a cell in Excel and Google Sheets.

How to split text in Excel and Google Sheets | Zapier

If you work with data that needs to be split—like separating first and last names—here's how to split a cell in Excel and Google Sheets. 

How to split text in Excel and Google Sheets

Leverage Facebook’s highly effective lead ads, and have all leads generated created as leads in BoomTown. Set them up on e-alerts based on their needs, and use our automation tools to start following up. 

Facebook lead ads make signing up for business information easy for people and more valuable for businesses. The Facebook lead ad app is useful for marketers who want to automate actions on their leads.

Facebook Lead Ads

New Lead

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.

Work with dates and times to change formatting or add/subtract time (with line-item support).

Date / Time

Work with numeric data to do math operations, reformat currencies, and more (with line-item support).

Numbers

Work with text data to find & replace, capitalize, remove HTML, and more (with line-item support).

Text

Various utilities like "choose value from list" or "look up in table" (with line-item support).

Utilities

BoomTown is a software platform designed to help real estate professionals generate leads, manage contacts, and run their business better.

BoomTown

Triggers when a call is logged for one of your assigned leads.

Call Logged

Triggers when a category is changed for one of your assigned leads.

Category Changed

Triggers when you receive a email from one of your assigned leads.

Email Received

Triggers when a lead submits a web inquiry or question on your BoomTown site.

Lead Asked Question

Triggers when a tag is added to an assigned lead.

Tag Added

Triggers when a tag is removed from an assigned lead.

Tag Removed

Triggers when you receive a text message from one of your assigned leads.

Text Received

Triggers when a To-Do is created for an assigned lead.

To-Do Created

Creates a new lead or updates an existing lead.

Create or Update Lead

Add new leads from Facebook Lead Ads to BoomTown

This integration will allow you to push leads that register via your Facebook ads into Chime. This automation will decrease the need for manually inputting your Facebook leads onto your platform. Have all leads generated created as leads in Chime and use our smart plan to start following up.

Lofty is a product of the technology company Lofty Inc, which offers a complete tech solution for real estate agents.

Lofty

Triggers when a lead is moved to the selected group.

Segment Changed

Triggers when a lead is moved to the selected pipeline.

Lead Pipeline Changed

New Transaction

Triggers when a new lead is assigned to you. Does not work for lender-type accounts.

Trigger this zap when a specific Smart Plan step with a unique "Zap Trigger ID" is run for a lead.

Smart Plan Action

Update Transaction

Find Record

Create Lead

Create Transaction

Update Lead

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

How to split text in Excel and Google Sheets

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.