Skip to main content

Parse after Punctuation

  • February 28, 2021
  • 2 replies
  • 22 views

Hi,

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.”

Thanks!

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • February 28, 2021

You could do something like this:

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


  • Author
  • New Participant
  • February 28, 2021

Perfect! This works great!