In this video I will show you how you can extract the Door and drawer front heights and widths and put them in their own columns. I will also show you how to remove the extra text in the door name.
To do this I will be using text to columns. I will also show you how you can use the replace method as well as the InStrRev and InStr functions and more.
Be sure to watch because I will also show you how to use the worksheet function “Trim” to remove all leading and trailing spaces that may exist in the text strings. This is a very valuable function to know especially if you are planning on doing lookups or other functions that require exact matches to work properly.