Or if the number of spaces were unknown:

arr = Split(sStr, Space(1))
becomes:
arr = Split(application.trim(sStr), Space(1))



Norman Jones wrote:

Hi Arnand,

I should have added that the string

"AAA BBB CCC DDD"

is in fact double spaced.

If this is intentional, change:

arr = Split(sStr, Space(1))

to

arr = Split(sStr, Space(2))

---
Regards.
Norman

--

Dave Peterson