Excel TEXTSPLIT Function – How To Use

The TEXTSPLIT function separates the input text into columns and/or rows as per the given delimiter. The resulting text is spilled into different columns and rows, creating an array. It is one of the most useful Excel functions for text structuring and editing.The TEXTSPLIT function is like the in-built Text to Columns functionality of Excel, … [Read more...]

Remove Conditional Formatting in Excel (7 Easy Ways)

Someone went overzealous with the visual ease of Conditional Formatting, slammed every Rule in the Conditional Formatting book, and made a circus out of a dataset. Too much Conditional Formatting is weighing your file down. Or maybe you're living a slightly easier work life than that and wanting to clear a Rule off the sheet is a small part of a … [Read more...]

Excel TEXTJOIN Function – How To Use

The TEXTJOIN function joins text or strings from multiple cells into one cell separating them using the given delimiter with an option to include or ignore empty strings. It was first introduced in Excel 2016.The TEXTJOIN function combines the values while adding the specified delimiter between each text. The return value of the TEXTJOIN function … [Read more...]

Ignore Blank Cells in Conditional Formatting (3 Easy Ways)

Conditional Formatting is the quickest and easiest way to add visual impact to any dataset but a Conditional Formatting Rule can be prone to its simplicity and might not be doing what you want it to do.Our problem at hand, for now, is Conditional Formatting also highlighting blank cells when we would rather have them un-highlighted (and no one … [Read more...]

Excel NUMBERVALUE Function – How To Use

The NUMBERVALUE function converts a number in text format to numerical format using the given decimal and group separators.The NUMBERVALUE function is very useful when downloading data in different country formats as it converts locale-specific values to locale-independent values.SyntaxThe syntax of the NUMBERVALUE function contains three … [Read more...]

Compatibility Mode in Excel – All You Need to Know About It

The file extension in your workbook's name should be .xlsx if you're using an Excel version post-Excel 2003. That’s not necessarily the case with everyone as they may be using older Excel versions with the .xls file extension.While your later version would be all accepting of .xls files, others' younger Excel would be unaware of certain features … [Read more...]

How to Get All Worksheet Names in Excel (2 Easy Ways)

You have made a decision. You are, Excel-ly, not walking the manual route unless you must. Whether the file contains a single worksheet or a single hundred, putting together a list of all the worksheet names is not a situation demanding that you take the manual route so here we are. Welcome to Exceltrick's guide on getting all worksheet names in … [Read more...]

Count Values Between Two Numbers in Excel (3 Easy Ways)

There has to be someone who it comes down to - to get the clerical work out of the way, fill the administrative shoes, fluff up the white collar. But sitting on the other side of an Excel screen, there’s no need for admin when Excel can be your minion. We’d say that we are counting today but that’s far from the truth; Excel is counting for us the … [Read more...]