October 25, 2016
Hi fellow Excel Addict,
I hope you're having a wonderful week. I feel so blessed to be living in Canada where, at this time of the year, Mother Nature is putting on a spectacular display of fall colors. I hope wherever you are in the world that Mother Nature is being nice to you as well.
In today's 'Excel in Seconds' tip, I'll show you why 'It's Easier to Concatenate without CONCATENATE'.
If you missed last Thursday's 'Excel in Minutes' tip, 'Use AutoCorrect to Quickly Recall Your Impossible-to-Remember, Complex Formulas', you can read it here now.
Please feel free to share my newsletter with your friends — they will thank you for it.
Hope you have a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
It's Easier to Concatenate without CONCATENATE
Although you can use the CONCATENATE function to combine multiple text strings into one text string in a single cell...
... maybe you'll find it faster and easier to do this by using ampersands (&) instead.
You simply type an ampersand between each cell that you click or type in this simple formula.
To keep all of the text from 'running together', you will need to use a space character (" ") to separate the various text strings.
The text you want to combine can be referenced from a worksheet cell or entered directly in the formula.
Personally, I never use the CONCATENATE function. I find it much quicker and simpler to type the formula using ampersands.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630