Hi,
Newbie here! Thanks for your help. I want to check a column of cells. Within each cell, A1 or any other cell, I would like to check for the text string "inclu" which will let me know if the words included, includes, including or include are duplicated within the one cell. I would then like the result to appear to the right of that column so that I know which cells I need to check.
Can you help with this?
Thank you,
Newbie
Type this in B1 to check cell A1:
=LEN(A1)-LEN(SUBSTITUTE(A1,"includ",""))>=12
gives "TRUE" if it is duplicated.
Drag down
Quang PT
You are perfection. Thank you so much for your help!
Nice to hear it works. Pls mark it "SOLVED".
counts the number of repeated occurences
=(LEN(A1)-LEN(UPPER(SUBSTITUTE(A1,"inclu",9))))/(LEN("inclu")-1)
☚ Click ★ just below left if it helps, Boo?ath?
Nice, thanks for adding that, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks