Use LEFT,MID,RIGHT functions

A2 = apple
B2 = boy

=IF(LEFT(A2,1)="a",LEFT(B2,1),"")
--
If this post helps click Yes
---------------
Jacob Skaria


"Farooq Sheri" wrote:

Is it possible to write a single Find statement in code that will search for
a first string in say Range("A2") and if true look for another string in
Range("B2").