Good morning,

I am using the following to separate SMITH, JOHN (B2) into SMITH (C2) and JOHN (D2):

=RIGHT(B2,LEN(B2)-FIND(", ",B2,1))

The problem that I am encountering is that D2 contains the leading space (after the comma) from the original entry. I tried to include that space in the FIND(", ",B2,1)) part of te formula, but it is not working. Can anyone help? Thank you