Mar 12 2018
09:42 AM
- last edited on
Jul 25 2018
11:20 AM
by
TechCommunityAP
Mar 12 2018
09:42 AM
- last edited on
Jul 25 2018
11:20 AM
by
TechCommunityAP
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
Mar 12 2018 09:56 AM
SolutionHi,
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.
Mar 15 2018 04:19 AM
Thank you very much ! I just replaced the , by ; in your formula and it worked!
Mar 12 2018 09:56 AM
SolutionHi,
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.