Paul
08-03-2009, 11:23 AM
I NEED SOMEONE TO EITHER CREATE A QUICK MACRO OR JUST FIGURE OUT A WAY TO DO THIS W/O MY INTERVENTION. I NEED THIS DONE ASAP AND I WILL PAYPAL YOU MONEY UPON COMPLETION.
BASICALLY...
I HAVE A EXCEL FILE W/ 3 COLUMNS:
PART#(COLUMN1,(20CHAR)), ID#(COLUMN2,(20CHAR)), DESC(COLUMN3)...
Currently column3 has random amount of characters depending on description, i need this column broken down into 45 char max with the remaining characters made into a separate record using the same column1/column2... it would probably be helpful to create a unique id for every record or number the records.
example:
12345, 67890, blah blah blah blah blah blah blah blah
i need it to be:
12345, 67890, blah blah blah blah,12345-001
12345, 67890, blah blah blah blah,12345-002
if you can do this PM me ASAP
BASICALLY...
I HAVE A EXCEL FILE W/ 3 COLUMNS:
PART#(COLUMN1,(20CHAR)), ID#(COLUMN2,(20CHAR)), DESC(COLUMN3)...
Currently column3 has random amount of characters depending on description, i need this column broken down into 45 char max with the remaining characters made into a separate record using the same column1/column2... it would probably be helpful to create a unique id for every record or number the records.
example:
12345, 67890, blah blah blah blah blah blah blah blah
i need it to be:
12345, 67890, blah blah blah blah,12345-001
12345, 67890, blah blah blah blah,12345-002
if you can do this PM me ASAP