Character spacing and breaking up content

I need a new process for converting info from our work management system into a format that our printer can handle. It uses a text file to print these handy equipment labels.

FYI, our standard label has 4 rows. The first is the Unique Identifier (system info), the second is the work management number assigned to that unique identifier, and the 3rd and 4th rows are the long desription of what that piece of equipment is.


My download from our work management system that looks like Columns A & B. To create a label to place on the equipment out in the field I need to break up the information in column B and then arrange everything like in Columns F-I. I’m also limited to 41 character spaces for each column (printer requirements for the size of the labels).

Basically the output I want is in Columns F-I. Again, Column H is limited to 41 characters, less to keep a full word together.

I’ve been able to get this code to work to break up the info in Column B but I need some help putting it all together.


Note this code was from another spreadsheet I had built that looks at stuff in Column F and then break it up into two parts and puts it in Column A & B. Need to incorporate everything into one spreadsheet too...

Please Login or Register  to view this content.

My worksheet is attached. Any thoughts on bringing it all together???

Thanks!

I've got the first of it transferred over:

Please Login or Register  to view this content.

Still working on breaking up the description and the 41 character space requirements.

Well I'm making some progress but now I have more questions...

Please Login or Register  to view this content.

The first part of code puts 3 spaces before the end of the description (another issue that you all helped me figure out).

The last bit of code breaks the description up into two cells based on the comma (,). Problem is, it leaves a space before the word "common" and when you click on the cell, it actually has ' Common as the start. I need to remove the ( ' ) and the space. Then work on the 41 character spacing limit...

I've made a lot of progress but I still need help splitting up text inside a cell.
How can I look at a cell and break it into two cells once I meet a 41 characters max limit all while keeping a whole word in the process (so it may actually only be 35 characters)???


My code so far is below. (sorry it is long)

Please Login or Register  to view this content.

I also found this handy code online to export to a text file with commas and quotes around it.

Please Login or Register  to view this content.