Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

With the function SUBSTITUTE() is possible eliminate the "JR" or "SENIOR" from the string. =SUBSTITUTE(A2;" JR";"")