Forum Discussion
TroyMacPherson
Qrew Cadet
Thanks Mark, I'll try that.
You're right, some of my Full Name entries have 3-4 names...
------------------------------
Troy MacPherson
------------------------------
JohnCrosland
2 years agoQrew Trainee
I would recommend using the Length and Part formulas. So, it would be something like If(Length(Part([Name], 4, " "))>2, Part([Name], 4 " "), Length(Part([Name], 3, " "))>2, Part([Name], 3, " "), Part([Name], 2, " "))
------------------------------
John Crosland
------------------------------
------------------------------
John Crosland
------------------------------