View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xnman xnman is offline
external usenet poster
 
Posts: 18
Default counting spaces in a string

I apologize for asking again but for some reason, I cannot read the old
messages after a certain time period.
I have a long string that contains words and spaces.
1. Is there an easy way of finding the position of the last space in the
string?
2. Is there an easy way to find all the positions of all the spaces?
3. Can parse be used to parse out the string into an array?

Thanks in advance
xnman