Today I wanted to be able to show the text which was stored in another cell, within a ‘string’ of text.
I wanted to have a name ‘John’ as plain text in cell C3. In cell A1, I wanted to be able to display ‘Hello <whatever is in cell C3>’.
My colleague Doug here at Best STL taught me how to do it: Concatenation.
This is the formula:
=”Hello “&C3
Simple as that.
Now I can update the name in cell C3 and all cells that reference will be changed instantly.
Thanks Doug!
If you have a lot of data in Excel and you want to find the highest or lowest number in a row, column or range of cells, Excel provides an easy way to produce this answer for you, without the need to sort your data.
Lowest number:
The Excel function to find the lowest number in a range is =MIN()
For example, say you have a lot of numbers in cells C5 to C15. If you want to find the lowest number in that range, and show the answer in cell C4, you would:
Note: if you want to include another set of data, simply separate each range with a comma. eg. “C5:C15,E5:E15″
Highest number:
Similarly, if you want to find the highest number, say from a new range of numbers, D5 to D15, you would use the =MAX() function.
So, if you want to show the answer in cell D4, you would follow these steps:
