Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the a set of strings - file paths - that follow this general
format: C:\My Documents\Tools\New Hampshire_1.xls C:\My Documents\Tools\New Hampshire_11.xls C:\My Documents\Tools\Vermont_2.xls So basically the state, underscore, and number. What code could I write to create a new string with only the New Hampshire_1 part? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Returning left part of cell before a character | Excel Discussion (Misc queries) | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
part of string | Excel Programming | |||
Use part of string | Excel Programming | |||
Returning an Array as part of creating a cell formula | Excel Programming |