Searching for a substring in a string
I need to know if the substring "QDS" is in the string "QDS-01-10-52-0001" and then place the number one (1) in another cell if the result is True!
Which excel 2007 function can do that?
Your help will be greatly appreciate!!!
Welcome to the forum.
FIND() for case-sensitive, SEARCH() for not.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
HOW TO MAKE A DATA VALIDATION TO BE ONLY A SINGLE LETTER eg. "R"?
err what is your question now?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks