=IF(ISNUMBER(SEARCH("WAL-MART",A1)),"WAL-MART",0)


" wrote:

im trying to simplify my personal bookkeeping. i import my data from
the bank as a .csv and want to transfer it to a second sheet without
all the jibberish. its set up with a vlookup etc. but what i can't
figure out is say my entry from shopping at wal-mart has
POS PURCHASE - WAL-MART #0822 WAL-MART
but i want to transfer it and say WAL-MART
i tried if(a1="*WAL-MART*","Wal-Mart",0) as a test but i guess it
didn't like the wildcards..
also what would be the best way to convert multiple entries, example
if i went to home depot, not wal-mart. would using or with if be the
best solution?
thanks in advance,
jeff