LumberJocks

eCabinets cut list in excel #15: Formatting eCabinets Five Piece Door Breakdown with excel Part 3

  • Advertise with us
Blog entry by ScottM1 posted 01-09-2016 06:21 PM 1093 reads 0 times favorited 0 comments Add to Favorites Watch
« Part 14: Formatting eCabinets Five Piece Door Breakdown with excel vba Part 2 Part 15 of eCabinets cut list in excel series Part 16: Importing excel tables into eCabinets Line Drawing Editor. »

Formatting eCabinets Five Piece Door Breakdown with excel Part 3

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.

Be sure to check out Formatting eCabinets Five Piece Door Breakdown with excel Part 1 and part 2.

-- Scott Marshburn,https://www.youtube.com/user/ecabinetstips, FaceBook, https://www.facebook.com/ecabinetstipsandtricks, Twitter, https://twitter.com/eCabinetstips



0 comments so far

Have your say...

You must be signed in to post the comments.

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com