SOLVED

What's the best Formula

Highlighted
Occasional Contributor

Good Afternoon,

I have a column with : Leather goods, Denim, Jersey, Accessories etc. For every cell that is equal to denim or jersey or coat or even shirts I would like to replace it by RTW, i would like the other celles (leather goods, handbags or accessories) to remain as is.

What's the best formula ?

 

Thanks!

Ch

2 Replies
Highlighted
Solution

Hi,

 

You can depend on a formula like this one:

=IF(OR(A1={"jersey";"coat";"denim"}),"RTW",A1)

Also, you can use Find and Replace tool.

Highlighted

Thank you very much ! I just replaced the , by ; in your formula and it worked!