=IF(ISNUMBER(SEARCH("-",A1)),"value_1","value_2")
HTH
Jason
Atlanta, GA
-----Original Message-----
I want to search a text/number string to see if it has a
dash "-" and if it
does, I want to insert a value and if it doesn't, I want
a different value
I tried...
IF(SEARCH("-",A2)0
....which works fine if the string does have a dash, but
bombs to #VALUE!
errror if the string does not have a dash
Any help appreciated!
.
|