| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating / extracting words within a cell
If you are working in VBA, then use the SPLIT() function. It will both
separate a phrase into individual words/numbers and will allow arbitrary field separators. -- Gary's Student "Glen" wrote: One other thought comes to mind. How to handle delimiters within text in cells or variables. Is it possible to define a globaldelimiter for example a "," or a "/". thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting parts of a cell when only certain words appear | Excel Discussion (Misc queries) | |||
| Separating numbers and words into separate columns | Excel Discussion (Misc queries) | |||
| Separating words in a single cell | Excel Discussion (Misc queries) | |||
| Separating Words From a Text String | Excel Programming | |||
| Extracting just the color words | Excel Worksheet Functions | |||
Threaded Mode
