=RIGHT (function)
I am looking to extract everything on the right of a " " (space) in a text
line.
I have a lit of names in the form of FN" "LN in column A.
In column B I want to extract the LN portion of column A.
I guess the next logical question would be if I extract the LN and it is in
column B can I compare column A to B and output the difference in column
C stripping off the extra space after the FN?
TIA
Phil
|