Jes.persona
New member
(MS Excel)? I've got a list of several thousand names. Names of people and names of companies. Each time a company is used, a specific symbol is added to show that it's a company. This symbol is sometimes before, and sometimes after the company name. I.e. the cell may or may not begin with this specific symbol.
Had it begun with this specific symbol, I know I could've used something like
=IF(LEFT(A1,1)="SYMBOL","1","0")
But since the symbol may be at any location in the cell I need it to search through the entire cell to find it. If there is such a symbol in the cell, return 1. If not, return 0.
I would rather not use any macros, but if you can't think of any formula I suppose that would work out as well.
I will make sure to select a best answer if a satisfying answer is given.
Had it begun with this specific symbol, I know I could've used something like
=IF(LEFT(A1,1)="SYMBOL","1","0")
But since the symbol may be at any location in the cell I need it to search through the entire cell to find it. If there is such a symbol in the cell, return 1. If not, return 0.
I would rather not use any macros, but if you can't think of any formula I suppose that would work out as well.
I will make sure to select a best answer if a satisfying answer is given.