Hey all,

I have formula:

=CONCATENATE(TRIM(RIGHT(A48,FIND("&",A48,1)-1)),",",RIGHT(A48,FIND("&",A48)-FIND(,RIGHT(A48,LEN(A48)))))
This takes this:
KNUD J & MARIA L HOSTRUP

And returns this:
HOSTRUP,HOSTRUP

when I want it to return this:
HOSTRUP,MARIA L

Without overcomplicating, does anyone know how I can take length after the ampersand and subtract the last word from that length?