| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Words From a Text String
Hi I am trying to separate word from a text string Damage,Scratch,F-F,In-Ops
into variables I have tried The Mid Function with Instr, but I am finding it most difficult. Can anybody help me please Thanks Charles |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Separating Words From a Text String
in VBA the Split function will split the string on commas into a zero-based
array Dim MyList() As String MyList = Split("Damage,Scratch,F-F,In-Ops", ",") For i = 0 To UBound(MyList) Debug.Print MyList(i) Next i "vqthomf" wrote: Hi I am trying to separate word from a text string Damage,Scratch,F-F,In-Ops into variables I have tried The Mid Function with Instr, but I am finding it most difficult. Can anybody help me please Thanks Charles |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formats to Find Words in Text String | Excel Worksheet Functions | |||
| How can I isolate the last two words in a text string? | Excel Discussion (Misc queries) | |||
| Extracting the last set of words from a text string | Excel Worksheet Functions | |||
| How do I do a multiple search using key words in a text string | Excel Discussion (Misc queries) | |||
| Help - Separating numbers appearing on the right of a text string | Excel Worksheet Functions | |||
Linear Mode
