I Have a cell A2 in Excel with: [BenQ ZOWIE XL2411P 24" LED 144Hz e-Sports][1] [1]: https://ift.tt/2JZZeUt I want extract phrases and transform them. If text contain "LED" so write "Display: LED | ". If text contain "144Hz" so write "Refresh Rate: 144Hz | ". How can I do it with one function in one cell?
Thanks
Aucun commentaire:
Enregistrer un commentaire