Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a set of data that has leading spaces before each substring, and i
want to extract one particular string that has somehow eluded me. I checked out Michelle Valeriano's samples and that allowed me to figure out all but one. So here is a couple of the data samples: Cell A3: tall_3 = 0003.00 -21.00 0.00 Cell A4: tall_4 = 5240.00 26.54 1.50 If I wanted to extract just the "-21.00" from A3 or the "26.54" from A4, how would I go about doing so using the SEARCH function? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding a Substring? | Excel Worksheet Functions | |||
Substring | Excel Discussion (Misc queries) | |||
Substring | Excel Discussion (Misc queries) | |||
Sumproduct based on substring? | Excel Worksheet Functions | |||
Vlookup using a substring for evaluation? | Excel Worksheet Functions |