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...

How to Convert Number to Words Without VBA

In my previous article, I had explained how to convert a number to words in Excel using VBA. I had written a number of code lines to achieve this....

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.