Thread: extracting strings from cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
  
Posts: 421
Default extracting strings from cell
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
Reply With QuoteReply With Quote