Thread: extracting strings from cell
View Single Post
  #7   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 Dave,

============
Or if the number of spaces were unknown:

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


Excellent improvemnt!

Thankyou!


---
Regards.
Norman
Reply With QuoteReply With Quote