% in mysql functionality in Excel

[ajw5173]

Hi,

In mysql if you are searching on %abc it will return anything that ends with abc no matter what is in the beginning. Is there an excel formula or function that does the same thing?

Thanks!

 

[live_excel]

Hello,

In excel you have to use *abc to get anything that ends with abc.

Thanks

 

[ajw5173]

Great! Thank you!

 

[ajw5173]

Would that like like %"acb" or "%abc"

 

[live_excel]

you can use this by 2 ways "*abc" and "*"&"abc"