Forum Discussion
MCFNeil
8 years agoQrew Captain
Evan,
You will want to use a combination of "Left" and "NotLeft" in a formula to separate out the first from the last. It will look something like this:
Let me know if that works for you.
You will want to use a combination of "Left" and "NotLeft" in a formula to separate out the first from the last. It will look something like this:
NotLeft([Full Name], " ")&", "&Left([Full Name], " ")
Let me know if that works for you.
- EvanBohan8 years agoQrew CadetThank you!