I recommend watching this excellent YouTube video – it demonstrates many great features you may benefit from:-
Category Archives: Uncategorized
Do you have a column containing parts of a full name….that you’d prefer to have in a single cell?
It’s very simple to combine them with a simple Excel formulae.
NOTE: It’s essential to include the double quote marks – and a space – to ensure the correct result.
If you need to do the reverse – split a cell into 2 or 3 (eg. for the first, middle and last name), see this article
~~~If you enjoy this article, please click on “Like” to let me know – and/or write a comment below