LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 553
Default Splitting String into Consitiutent Parts including spaces characte

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Splitting up data by spaces Nick C Excel Discussion (Misc queries) 2 June 12th 08 01:24 AM
Splitting a file with lookup functions into smaller parts Dave McD Excel Worksheet Functions 3 October 25th 07 12:04 AM
Including spaces in filters steev_jd Excel Discussion (Misc queries) 4 August 10th 06 02:43 PM
COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL? zurafz6 Excel Worksheet Functions 7 March 6th 06 07:53 AM
Painting my kitchen exposed parts (including ceiling) David Smithz Excel Discussion (Misc queries) 2 March 4th 06 12:31 AM


All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"