Excel VBA Examples

Remove Trailing Spaces from Cells in Excel

This post will guide you how to remove leading and trailing spaces in cells in Excel. How do I remove leading or trailing spaces in a range of cells with a formula in Excel. How to remove trailing spaces from cells with VBA Macro in Excel. Remove Trailing Spaces from Cells with Formula If you… read more »

Convert Numbers into Words in Excel

This post will guide you how to convert numbers into words in Excel. How do I convert a numeric word into English words with VBA Function code in Excel. How to convert Numbers (Currency) to words with Excel VBA User Defined Function. Convert Numbers into Words The Excel doesn’t have a default function that displays… read more »

Hiding or Showing the Status Bar with Excel VBA

This post will guide you how to hide or display the status bar in Excel. How do I hide or display the status bar with Excel VBA macro code. Hiding Status Bar If you want to hide the status bar in your current workbook in Excel, you can use an Excel VBA macro to achieve… read more »

Reverse the Word Order within a Text String in One Cell

This post will guide you how to reverse the word order within a text string in one cell in Excel. How do I reverse list of words in a text string separated by space character with VBA Macro in Excel. Reverse Word If you want to reverse the word order in a text string in… read more »

Reverse Text String in Excel

This post will guide you how to reverse text string in Excel. How do I reverse text string in one cell with an Excel User Defined Function. How to reverse a text string in one cell with a formula in Excel. Reverse Text String with User Defined Function You can easily write down a User… read more »

Delete All Hidden Rows or Columns in Excel

This post will guide you how to delete all hidden rows or columns in Excel 2010/2013/2016. How do I efficiently delete all hidden columns and rows in a worksheet in Excel. How to delete all hidden rows or columns with VBA macro in Excel. Delete All Hidden Rows or Columns in Excel If you want… read more »

Find and Replace Multiple Values in Excel

This post will guide you how to find and replace multiple values at once with VBA macro in Excel. How do I make multiple find and replace in Excel. Find And Replace Multiple Values in Excel Assuming that you have a list of data in range B1:B6, and you want to find multiple values and… read more »

Change Uppercase to Title Case or Sentence Case in Excel

This post will guide you how to change uppercase letters to sentence case with a formula in Excel. How do I change uppercase to title case in Excel. How to change Uppercase to title case or sentence case with VBA macro in Excel. Change Uppercase to Title Case If you want to change uppercase letters… read more »

Create a Searchable Drop Down List in Excel

This post will guide you how to create a searchable drop down list in Excel. How do I create an excel drop down list with search suggestions in Excel. How to search data validation drop down list in Excel. Create a Searchable Drop Down List If you want to create a searchable drop down list… read more »

Convert Column to Comma Separated List in Excel

This post will guide you how to convert column list into a comma separated list in one cell in Excel. How do I convert a column into a comma separated list with a formula in Excel. Or how to convert a column into comma delimited list in Excel. Convert Column to Comma Separated List in… read more »

Sidebar