Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a string which has had elements removed creating variable spaces (have
shown spaces with dashes): -$A7-$B$11-----$I$2-$I$6--I6--------1-3-3-$I$6-K$3 I want to be able to split this string into its consituent parts (spaces included). I am not sure if using the split function will work as I am not using the spaces as delimiters. I want to be able to split as follows: Substring1 = - Substring2 = $A7 Substring3 = - Substring4 = B$11 Substring5 = - Substring6 = - Substring7 = - Substring8 = - Substring9 = - Substring9 = $I$2 etc...... Can anyone tell me what other options I have for this besides Split? Or if Split can in fact do this. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Splitting up data by spaces | Excel Discussion (Misc queries) | |||
Splitting a file with lookup functions into smaller parts | Excel Worksheet Functions | |||
Including spaces in filters | Excel Discussion (Misc queries) | |||
COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL? | Excel Worksheet Functions | |||
Painting my kitchen exposed parts (including ceiling) | Excel Discussion (Misc queries) |