Google sheet - searching a word within sentence

[wei_loon_Kee]

Hi, can i please check if it is possible to partial search for a word in google sheet?

For example, search and return rows which contain “apple”, the cells could be “apple orange and grape”.

Thanks

[DanielBeckett]

Hi @wei_loon_Kee

Unfortunately Google Sheets only support exact searches. There’s no partial matching.