multiple conditions recoding

[bwhamilton]

hey guys.

I have a column with a bunch of promotion types that have to be recoded to a specific format. I can think of a few ways to do it by using if statements in a macro, but no way to basically count the number of entries within a cell (i.e. buy one get one free, rebate, loyalty card = BOGO + 2 other promos).

for example:
A cell may contain: 50% Off, Loyalty Card Required, Other Purchase Required / Buy/Get - Other, Loyalty Card Required

This cell would have to get recoded Discount + 3 other promotions (3 entries separated by commas after the initial entry of 50% off).

I dont know if this makes sense, but I could really appreciate any help.

 

[Scott Huish]

Do you need a macro or will a formula do?

Assuming that text in A1:

=IF(A1="","","Discount + " &LEN(A1)-LEN(SUBSTITUTE(A1,",","")) &" other promotions")