Hi!

strResult = StrTran(StrTran(StrTran(strResult,' ',' '),' ',' '),' ',' ')
Above will work for max.8 spaces. Next strTran will handle 16 spaces. 2 more - 32 spaces between words.

HTH.

>Hello All,
>easy peasy one for you experts, I need a function to remove extraneous embedded spaces from a given string of multiple words, and wondered if any of you have experience in this area, an example of I show below
>
>

>cStringIn = 'Peter the embedded      space    man'
>
>
>cStringOut = 'Peter the embedded space man'
>
>

>
>
>
>many thanks
>
>Pete Kane

Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.