I'm writing a Microsoft Excel Macro that copies information from one sheet in a workbook to another and concatenates the values to create a single string. The string is then used in a batch file to upload to a mainframe system.
I have one issue where one of the fields (JVNumber) is not always a set amount of spaces. The field can range from having 4-8 characters. When I copy and paste that value in my spreadsheet, is there a way that I can pad the spaces a certain amount. After the field JVNumber which is in place 32, the next field is not until space 50. Any approach would be really helpful.
I really need help and can confirm you will get 500 points and an A.
Thanks!
After that field on my string, I have another
Start Free Trial
