Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

List Separation

  Asked By: Diane    Date: Oct 19    Category: MS Office    Views: 652
  

I want to separate the list based on the delimeter and store it in
to a string
e.g
In a cell I have values [31],[32],[31:0]............ n number of values
So my code needs to put [31] in a separate string [32] in a separate
string [31:0] is a separate string and so on .....
Is any function available or has someone already implemented logic for
this.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Xander Thompson     Answered On: Oct 19

I just did a quick macro record

Range("D8").Select
ActiveCell.FormulaR1C1 = "1,2,3,4"
Range("D8").Select
Selection.TextToColumns Destination:=Range("D8"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=True, Space:=False, Other:=False, _
FieldInfo :=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)),
TrailingMinusNumbers:= True

 
Didn't find what you were looking for? Find more on List Separation Or get search suggestion and latest updates.




Tagged: