Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Manipulation
Hello €“
I have a cell whose contents are C,C,C,D,D,C,C,C,C,C Im looking for direction on how to store that in a variable and spit out each letter into individual cells. Text to column is not the optimal approach as there is more to the model that is described here. I need to learn a different approach€¦ Sincerely, Arturo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Manipulation
Hi,
Try this: Sub SplitMe() Dim v As Variant Range("a1").Select v = Split(ActiveCell, ",") For i = 0 To UBound(v) Cells(i + 1, "B") = v(i) Next i End Sub HTH "Arturo" wrote: Hello €“ I have a cell whose contents are C,C,C,D,D,C,C,C,C,C Im looking for direction on how to store that in a variable and spit out each letter into individual cells. Text to column is not the optimal approach as there is more to the model that is described here. I need to learn a different approach€¦ Sincerely, Arturo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data manipulation help | Excel Worksheet Functions | |||
Data Manipulation. | Excel Discussion (Misc queries) | |||
Help with data manipulation | Excel Discussion (Misc queries) | |||
Need help with some data manipulation | Excel Worksheet Functions | |||
Data manipulation | Excel Discussion (Misc queries) |