Hey all,
I have this:
if no comma before first ampersand, then that means last name is at end of cell, so we take content after third space after the ampersand and place it in front and then place a comma and then take content after ampersand and put directly after comma:
And then in next column, we do above but instead this time we take content before ampersand and stick it after comma:
I'm stuck trying to figure out how to get content after third space after ampersand:
=IF(ISERROR(FIND(",",LEFT(A36,FIND("&",A36)-1),1)),CONCATENATE
,FALSE)
Thanks for response.
Bookmarks