View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
 
Posts: 989
Default number of spaces...

Hello.

I know someone showed me this before, but I've forgotten.

If I wanted to do a count of the number of spaces within a single cell, how
could I do that?

For instance, if I wanted to look at a cell that contained 'A B C D', and
get the answer that there are three spaces in that.

Thanks.
Mark