Find "space"

D

Danny

Hi,

Please help me write a macro to find space(s).

Example:

aa bb cc dd ee
=MID(A1,FIND(" ",A1)+1,2) = "bb"

To write a macro, how will I find/write the other spaces
so I can use the MID funtion to extract "cc" and "dd"?

Thanks
 
Top