Help needed with formula
I have a column that brings in whatever was typed into the PO field on an order form. People mostly put in their name, and often some other text to indicate their region or department. I need to find a forumula to extract just the name and display it in last, first format.
This is an example of the data:
JAMES MCDONALD 21946
AARON TULLOCH/ PNW
ANGEL CRUZ- NEW HIRE
Help Article Resources
Check out the Formula Handbook template!