📞 01223 214177 ✉️ karen@roem.co.uk
This week's tip is inspired by Sian Gardner who asked whether Flash Fill can be used to separate first and last names if there are double-barrelled surnames.
The short answer is: Yep!
Here's how:
It even gets the hyphenated name correct. And if you don't like it you can undo the revision. But why would you?!
I didn't know this, Sian, so thanks for the question and for this week's tip inspiration.
Related tips
This week's CleverClogsTipTime on LinkedIn
*
Unless stated otherwise this tip is written for Microsoft 365 desktop apps and Windows 10 users, but might also be useful in Office 2010, 2013 and 2016.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.