The cell can contains any characters, for example, how to write a function to test if there is a specific variable in the cell?
Given:
1) Variable can be only letter.
2) The cell string is in UPPER case status, so no need to consider LOWER case letter.
Examples, test if below equation contains variable ABC:
(ABCD + BHY)*2 > BUJ : It should return FALSE, since ABCD is not same as ABC.
(AABC + BHY)*2 > BUJ : It should return FALSE, since AABC is not same as ABC.
(KABCD + BHY)*2 > BUJ : It should return FALSE, since KABCD is not same as ABC.
(ABCD + BHY)*2 > ABC : It should return TRUE.
ABC + BHY*2 > BUJ : It should return TRUE.
Thanks.
Bookmarks