Find and Replace is a simple feature we all know and love when working in Word or Excel…
But if you’ve ever tried to find and replace text with an *, you’ll know that any text following the * is deleted! We can solve your problem with this one easy step!
Open find and replace
(Hit Ctrl + H on your keyboard for Windows or hit Ctrl + F on a Mac)
In the ‘Find What:’ box, type the text you want to replace, but add a tilde (~) before the * (e.g Kleenex~*) – that’s the clever bit!
In the ‘Replace With:’ box, add the text you want to replace it with (e.g Kleenex®)
…and there you go! You’ve replaced the * without deleting the rest of your text! 🙌