This may be straightforward or impossible.....I use an excel doc for a rota/planner. One row only ever contains various staff names. This might seem lazy but can I use conditional formatting to automatically replace first names with full names eg if I type "john" could it immediately change it to "John Smith"?
I'm aware I would have to tell it all the potential replacements but there are only about 10 names so would love to know if it's possible.
The reason I want it is because I have a macro that generates an email involving names in this row so they need to be formalised/consistent.
Many thanks.
Bookmarks