Monthly Archives: February 2016
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
If you or your contacts would like assistance in using this (or other) features it would be best to ask for support from an technician who can provide remote support. This way, it can only take a few minutes – Julia provides this service, so why not click here to enquire