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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Excel filter 5
Get Column Header if Condition is Met 0
Unique value list 3
Sumproduct or ????? 5
SUMPRODUCT 5
Cell Counter/Increment 2
lookup for last value in a row 12

Top