Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Parse after Punctuation

Topic Labels: Formulas
331 2
Showing results for 
Search instead for 
Did you mean: 


I have data that looks like this:

123: Tom Smith
11: Sally Smith
1200: John Doe

I would like to extract just the name with a formula. I know I need to use RIGHT/LEFT, but I can’t quite figure out how to say “extract all text after the colon.”


2 Replies 2

You could do something like this:

RIGHT({Text Field},LEN({Text Field})-FIND(": ",{Text Field})-1)

Perfect! This works great!