×

VBA Text Manipulation

VBA Code To Highlight All Instances of Word/Phrase Within A Range

VBA Code To Highlight All Instances of Word/Phrase Within A Range

What This VBA Code Does Have you ever had to search through a large Excel spreadsheet to find specific text?...

Clean Up Superscript & Subscript Text in Excel Data

Clean Up Superscript & Subscript Text in Excel Data

Dealing With SuperScripts/Subscripts Sometimes you receive data or copy data that has superscripts or subscripts that you really don’t want...

VBA To Add A Prefix to Selected Cells

VBA To Add A Prefix to Selected Cells

What This VBA Code Does In my day job, I often have to add a prefix to thousands of ID...

VBA To Remove/Delete Superscripts From Excel Cell Text

VBA To Remove/Delete Superscripts From Excel Cell Text

What This VBA Code Does I have run into a couple of instances recently where I needed to clean up...

VBA To Change Text Case Within A Selection Of Cells

VBA To Change Text Case Within A Selection Of Cells

What This VBA Code Does The following VBA macro code is something I use all the time to manipulate the...

Generate A String Of Random Characters With VBA Code

Generate A String Of Random Characters With VBA Code

What This VBA Code Does This VBA macro function will allow you to generate a string of characters at random...

Apply Math to all Numerical Values Embedded in Text With VBA & Regular Expressions

Apply Math to all Numerical Values Embedded in Text With VBA & Regular Expressions

What This VBA Code Does This VBA code will use the power of Regular Expressions to parse through text and...

A Fast Way To Clean & Trim Cell Values With VBA Code

A Fast Way To Clean & Trim Cell Values With VBA Code

What This VBA Macro Code Does I found this code snippet on an Ozgrid forum post written by a fellow...

Count The Number of Character or Phrase Occurences Within A String With VBA

Count The Number of Character or Phrase Occurences Within A String With VBA

What This VBA Code Does Whether you are wanting to know how many times a double 'S' appears in the...

Classified Data: Find All Numbers And Replace Them With X's In Text

Classified Data: Find All Numbers And Replace Them With X's In Text

Recently I found myself in a situation where another company wanted to see the formatting of numerous reports and presentations...

Create A Multi-Line Text String

Create A Multi-Line Text String

What This VBA Code Does If you want to create multiple lines of text you can either use vbNewLine or...

Find All Instances With VBA

Find All Instances With VBA

What This VBA Code Does This VBA macro with let you specify a value and create an Excel range selection...

Find and Replace All With Excel VBA

Find and Replace All With Excel VBA

What This VBA Code Does These VBA macros will show you various ways to find and replace all for any...

VBA Pattern Validation (Characters And Numbers)

VBA Pattern Validation (Characters And Numbers)

Today we are going to discuss how you can use VBA to ensure that cell values match a specific pattern. ...

Bold The Last Word Of Text In A Cell

Bold The Last Word Of Text In A Cell

What This VBA Code Does This bit of VBA code looks at a text string within a specified cell and...

Remove Last Character From String

Remove Last Character From String

What This VBA Code Does I typically use this kind of functionality if I am trying to compile a list...