The T function is a text function that determines whether the input data is text or not. If the data is a text value, the function returns the input data in its original form whereas it results in an empty string for all non-text input values.The T function is highly beneficial when we wish to eliminate values that are not text making it easier … [Read more...]
How to Find a Named Range in Excel (4 Quick & Easy Ways)
All is looking upright in Excel; you've been so organized, have stacked all the worksheets in the most logical order, and have obsessively named over a dozen ranges down to the T. That is what Named Ranges are for, after all, to make the usage of a cell or a range easier in your spreadsheet life.That is just great going but how far are we falling … [Read more...]
Excel ARRAYTOTEXT Function – How To Use
The ARRAYTOTEXT function is used to convert any range of values into a single text string. The function simply combines the data from an array of cells into a single cell resulting in one text value or array. Depending on the format, the ARRAYTOTEXT function separates the data using either commas (,) or semicolons (;).The ARRAYTOTEXT function is … [Read more...]
Formula Bar in Excel – How to Show, Hide or Resize
The Formula Bar in Excel has more to it than what meets the eye and today's tutorial will give you a rundown on it. (A run down and up if we're honest!)The Formula Bar is one of the core features of Excel and we will guide you on what it is, how to hide/display, expand/contract it, and how to use formula bar icons.Let's get formulating!What … [Read more...]
Excel VALUETOTEXT Function – How To Use
The VALUETOTEXT function is used to convert any value to text format. If the input value contains numeric formatting such as date or time, the resulting data loses the format.The VALUETOTEXT function is worthwhile when we wish to gain compatibility with other spreadsheet programs, especially when the resulting data needs to be further … [Read more...]
How to Group & Ungroup Worksheets in Excel (Easy Steps)
Copy-paste the dataset to one sheet, the next, and also the next. Then a new formula to the same sheets one by one, you guessed it, again. You didn't take the Excel life to be so clerical now, did you? No sir! You will be thrilled to find out that such days are behind you, thanks to Excel's grouping and ungrouping worksheets feature. What you apply … [Read more...]
How to Select Only Visible Cells in Excel (Shortcut + VBA)
Does not sound like an issue, right, because how would you even select cells that aren't visible? You would and that is no magic or the lack of it; that's just a very regular way of Excel. A demonstration you say? Good idea. Let's show you how you'll end up selecting hidden cells with an example. Below we have a dataset of product quality scores … [Read more...]
How to Highlight Expiry Dates in Excel (Step-by-Step)
Expiry dates are not best before dates and carry a higher element of urgency. Expiry dates guide the course of action for saving the articles from expiring. Perishable goods, subscriptions, registrations; some things will need to be renewed, the others disposed of. And keeping a track of things has never been a bad idea.Working on that good idea, … [Read more...]
