How to get the top level domain (tld) from URL in Excel

In this article, we will learn How to get the top level domain(tld) from URL in Excel. Scenario : First we want to understand what a top lev...

How to Find Any Special Characters in a String in Excel

We know that TRIM and CLEAN Excel functions are used to clean up unprintable characters and extra spaces from strings but they don't help much in ...

How to Remove Numbers From Alphanumeric String in Excel

We have learned how to strip numeric values from a cell in excel 2016 and older. The formulas we used were a little bit complex but now Excel 2019...

How to Combine Cells With Comma in Excel

So earlier we had CONCAT, and CONCATENATE function to concatenate multiple cells. But if we wanted to supply a range for joining cells with a deli...

How to Remove Non Numeric Characters From Cells in Excel

We have learned how to strip numeric values from a cell in excel 2016 and older. The formulas we used were a little bit complex but now Excel 2019...

How to Find 2nd, 3rd or Nth Occurrence of a Character in a String

To find the first occurrence of a character in Excel we use the FIND of SEARCH function in Excel. But if we want to find the second occurrence of ...

Excel CHAR(10) Not Working. How to Solve It?

Activate the Wrap Text  to make CHAR(10) formula work. So in my previous article, I had told you how to use the CHAR(10). The CHAR(10) formula...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube