G
Guest
Is there a way to do an IF statement where if a specific word is in a
multiple word description, I could put that word in a different column. I
have hundreds of item descriptions for a nut category and would like to
create a TYPE column for the different types of nuts.
For example, if the descriptions was PL PEANUT NUT SNACK, then the word
PEANUT would go in the type column in that row. Or if PL ALMOND NUT SNACK
was the description, then ALMOND would go in that column.
Was thinking of an If/Then statement, but don't know how to tell it to look
for that specifice word in the cell.
multiple word description, I could put that word in a different column. I
have hundreds of item descriptions for a nut category and would like to
create a TYPE column for the different types of nuts.
For example, if the descriptions was PL PEANUT NUT SNACK, then the word
PEANUT would go in the type column in that row. Or if PL ALMOND NUT SNACK
was the description, then ALMOND would go in that column.
Was thinking of an If/Then statement, but don't know how to tell it to look
for that specifice word in the cell.