Finding any occourrence of a character in a string

[Anthony47]

Hi everybody,
in a string like "Dear friends please I need your help" how can I get the position of the first, the second, the third and so on position of a specific character, for example the "space"?
Now I do that via Udf, but I should do the job without using vba, if possible.

Thanks for your help.

 

[pgc01]

Hi

Assuming the string in A1, in B1:

=FIND("#",SUBSTITUTE($A1," ","#",COLUMNS($B1:B1)))

Copy to the right. It will give you the positions of the spaces in the string.

 

[jim may]

=find(" ",a1)

 

[Anthony47]

Many thanks to both of you for your answers.
pgc01's formula does perfectly the job, ie the possibility of finding not only the first occourrence of the character but also the second, third and so on.

Thanks again.