Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fastest way to store each word in a cell in a diff variable
If I have a cell with words in them separated by spaces, what is the
fastest/easiest way to store each word into a variable? (Non Text-to-Column way) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fastest way to store each word in a cell in a diff variable
Try something like this:
Sub test() Dim i As Long Dim str As String Dim arr str = Cells(1).Text arr = Split(str, " ") For i = 0 To UBound(arr) Cells(i + 1, 2) = arr(i) Next i End Sub RBS "J@Y" wrote in message ... If I have a cell with words in them separated by spaces, what is the fastest/easiest way to store each word into a variable? (Non Text-to-Column way) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find a word and copy all rows with this word to diff ws | Excel Programming | |||
Store the format of a cell in a variable | Excel Programming | |||
Way to store cell location to variable? | Excel Programming | |||
Store cell data in a variable | Excel Programming | |||
store variable | Excel Programming |