How would I write an IF statement that instructs Excel to evaluate the first
six characters in a given cell? By that I mean, IF(A1 begins with ABCDEF,
then, ,). IF(A2 begins with GHIJKL, then, ,). Hmm, I will need several of
these IF's in a row since the contents could begin with about 8 differing
text patterns. How would I string the IF arguments together?

I want to perform a REPLACE on a group of cells that contain brand names.
Different brand names, different string lengths, therefore the need for the
IF statements.

Thanks....