OzGrid

 

What this code allows you to do is circumvent testing (ie looping) each individual cell and handling trimming (removing leading and ending spaces) and cleaning (removing unprintable characters) process for your Excel data. It's a great way to clean up your data getting exported from an outside database.

 

Obtained from the OzGrid Help Forum.

Solution provided by royUK.

 

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets

 

See also:

How to use Excel VBA userform list box

How to maximise IE window in VBA

How to generate multiple line charts VBA

How to create VBA to copy specific column from one sheet to another

How to use VBA to returning 5 left digits and pasting to bottom of existing data set

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.