Cell A1 contains a Customer's name in either of these two formats:
LAST, FIRST
LAST, FIRST MIDDLE (sometimes the middle name is only a letter)
We want Cell B1 to contain only the first name for either of the two formats above.
Thank you in advance for help with this.
Bookmarks