Hi all,
I have a column of company names (B1:B40000) and want to identify in a seperate column (A) which company names include the word "Trust".
I was thinking of a formula much like the following:
=IF(B1="Trust","Public Sector","")
However, this only works where the cell value is exactly "Trust". Is there a way of ammending this so that if the cell value is "National Trust" it is still recognised?
Perhaps something like this?
=IF(B1="*Trust*","Public Sector","")
Thanks everyone!!!
I have a column of company names (B1:B40000) and want to identify in a seperate column (A) which company names include the word "Trust".
I was thinking of a formula much like the following:
=IF(B1="Trust","Public Sector","")
However, this only works where the cell value is exactly "Trust". Is there a way of ammending this so that if the cell value is "National Trust" it is still recognised?
Perhaps something like this?
=IF(B1="*Trust*","Public Sector","")
Thanks everyone!!!