G
Guest
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!
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!