View Single Post
  #1   Report Post  
Philippe L. Balmanno
 
Posts: n/a
Default =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