Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
You're welcome !
As RD said <g, here we could have used FIND instead of SEARCH FIND is case sensitive while SEARCH is not, but it doesn't matter here since we're looking for the "-", not alphas -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "anar_baku" wrote in message ... Thanks guys, this worked! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
String Extraction... | Excel Worksheet Functions | |||
Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
Improvements for text finding functions | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |