Maybe more of an Excel question, but nevertheless....
I have a customer that has listed how they want all their I/O tags documented in an Excel spreadsheet. Unfortunately, each description is in a single cell, and as far as I understand, SLC expects comma delimeted descriptions in 5 fields of 20 characters each. So, is there a way to get all these descriptions that are in one cell into 5 cells of 20 characters each and split on word boundaries?
I have a customer that has listed how they want all their I/O tags documented in an Excel spreadsheet. Unfortunately, each description is in a single cell, and as far as I understand, SLC expects comma delimeted descriptions in 5 fields of 20 characters each. So, is there a way to get all these descriptions that are in one cell into 5 cells of 20 characters each and split on word boundaries?