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
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