Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
============
Or if the number of spaces were unknown: arr = Split(sStr, Space(1)) becomes: arr = Split(application.trim(sStr), Space(1)) ============ Excellent improvemnt! Although some may not consider this an improvement because it is not as clear as to what is going on, but the space character is the default delimiter for the Split function, so, in this case, it can be omitted... arr = Split(application.trim(sStr)) Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting numbers from alphanumeric strings | Excel Worksheet Functions | |||
extracting numbers from alphanumeric strings | Excel Programming | |||
Extracting time from strings | Excel Programming | |||
2 more questions about extracting numbers from text strings | Excel Discussion (Misc queries) | |||
extracting numerics from literal strings | Excel Programming |