Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello - Dim A as string Dim brkout() as string Dim B as string, C as string, D as string, E as string, Leftover as string A contains text. I am trying to store the first 4 substrings of A in B, C, D, and E. Then I want whatever else is left to be stored in Leftover. The delimiter for the substrings is ".." I have been able to use the SPLIT() function to store the first 4 strings using brkout=split(A,"..") then B=brkout(1):C=brkout(2):D=brkout(3):E =brkout(4) How do I store the remaining text left in brkout() (apart from B,C,D and E) in Leftover? Any help would be appreciated. Jay *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Substituting substrings | Excel Programming | |||
Macro Help for Substrings | Excel Programming | |||
sum wrt substrings! | Excel Worksheet Functions | |||
Substrings in Excel? | Excel Discussion (Misc queries) | |||
STRINGS AND SUBSTRINGS ! | Excel Programming |