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