I am trying to isolate characters before and after a comma in a cell.
It is not working though, as it is sometimes including the comma as well as other characters.
For instance the following should be JUAN but I am getting , JUAN.
There are other variations.
I need the name before the comma and the name after the comma.
I am using =RIGHT(C4,(FIND(",",C4,1)-1)) and =LEFT(C2,(FIND(",",C2,1)-1))
The LEFT works well but the RIGHT does not.
Can anyone help please!???
|ARRE, JUAN||, JUAN|