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
Do you have a column containing a full name, like this:-
….that you’d prefer to have separated into first and last name ?
It’s very simple to separate them using a few steps in Excel. Here’s how:- Read the rest of this entry
If you need to fill in a range of headings, or a column of data, Autofill can really save you time. It can be used for consecutive numbering, days of the week, months of the year, years (such as 2014, 2015 …..) and much more. As long as you have at least the first 2 entries, Excel can generally guess how to continue the series.
Here’s an example of how you begin:-
By default, the Quick Access Toolbar is within the program’s Title Bar (as you’ll see in the screenshot below).
Many users find the Quick Access Toolbar easier to use in a slightly different position – underneath the Ribbon as you can see here:- Read the rest of this entry
The default cell doesn’t allow much room for typing text, does it?
To extend a column’s width, move the mouse pointer over one of the small divider lines that separate the alphabetic headers at the top of the sheet.
When the pointer changes to a double-headed arrow (as you can see in the picture above), press the left mouse button and keep it down whilst you drag the column out until it is wide enough.
The same procedure applies for adjusting row height (ideal if you want to use a larger font) as you place the mouse between the rows and drag.
Bonus Tip – You can automatically size Column A to fit the text inside by simply double-clicking on the border whilst you see the double-headed arrow.
If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 🙂