| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting text before a known character
just adding to charle's code, if you don't want the underscore
var1 = Left(str1, InStr(1, str1, "_") - 1) -- Gary "Charles Chickering" wrote in message ... Var1 = Left(str1, InStr(1,str1,"_")) -- Charles Chickering "A good example is twice the value of good advice." "Barb Reinhardt" wrote: I'd like to extract all text in a string that appears before an underbar. How would I do this programmatically? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting characters before or after a specific character | Excel Worksheet Functions | |||
| extracting sheets on the basis of Row character | Excel Worksheet Functions | |||
| extracting data to the right of a set character | Excel Worksheet Functions | |||
| looping thru range extracting data based on character | Excel Programming | |||
| Extracting a character from a string of characters | Excel Discussion (Misc queries) | |||
Linear Mode
