Nir wrote...
Biff
i would like to use it in case there are no space in the string.
use the example below if:
D1=II
D2=IO
D3=IIO

so formula resualt will be only "IIO"

Difficult. D1 = "II" and D2 = "IO" are substrings of D3 = "IIO". You'd
need to set up your search so it located IIO first, then either II or
IO. So if you're searching for any of these substrings in a string
named x, try

=LOOKUP(1000000,SEARCH(D1:D3,x),D1:D3)

which doesn't require array entry.