If you want to place a note inside an Excel formula you can use an old function that is, in most cases, redundant. The N function was used in early spreadsheets, but is hardly ever used in modern formula.
Tag Archives: text
Counting Characters in Excel
Another useful SUMPRODUCT technique
If you need to know how many characters are in a cell then use the LEN function. What if you wanted to know how many characters were in a range?
Quick as a Flash with Excel 2013
A new feature that's not perfect yet
Excel’s brand new Flash Fill feature can be a time saver, but it’s not fool proof. Flash Fill is a new feature in Excel 2013.
How to get to first place in Excel
Or second and third
If you need to convert a number to its ordinal so that 1 = 1st and 4 = 4th then there is no built function to do it, but you can write a formula to do it.
Excel’s shorthand shortcut
Save typing
Excel has a feature that can save you a lot of typing, it’s called AutoCorrect. Yes it’s the same system that fixes your spelling mistakes. Well did you know it has two handy features?
Creating Dynamic Text Box entries in Excel
Flexible text
Text boxes are flexible because you can place them anywhere on your spreadsheet.
You can link a text box to the contents of a cell.
Joining Text in Excel the quick and easy way
BAN CONCATENATE!
The CONCATENATE function is redundant. You don’t to need to use it. There is a much quicker + easier way to join text together.