Thread: Reverse Find
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Reverse Find

This will work, if there are ALWAYS two blanks in the cell. It works
by nesting a Find within a Find, starting the outer Find using the
inner Find as a parameter. It subtracts that result from the overall
length of the string itself, adding 1 to account for the non-zero
start.

=LEN(A1)+1-FIND(" ",A1,FIND(" ",A1,1)+1)