What's the best Formula

[null null]

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 · Accepted 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.

[#3]

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