mercredi 11 novembre 2020

Find and replace especific text in Excel

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