I have 90-120 character strings in Column A. I need Column B to take the first 40 whole word characters and Column C to take the remaining characters up to 800.
I have been researching a solution to this problem and everything I have seen has been slightly off from what I am looking for. I am trying to do this in VBA to stream line the process because I have 30 Spreadsheets each with over 1500 lines.
Example of what I need:
<tbody>
</tbody>
I have been researching a solution to this problem and everything I have seen has been slightly off from what I am looking for. I am trying to do this in VBA to stream line the process because I have 30 Spreadsheets each with over 1500 lines.
Example of what I need:
Column A: Original Message | Column B: First 40 Characters | Column C: Remaining Characters | Len (A) | Len (B) | Len (C ) |
Thank you for registering at the MrExcel Message Board. Before we can activate your account one last step. | Thank you for registering at the MrExcel | Message Board. Before we can activate your account one last step. | 106 | 40 | 65 |
Please be sure not to add extra spaces. You will need to type in your username and activation number on the page. | Please be sure not to add extra spaces. | You will need to type in your username and activation number on the page. | 113 | 40 | 73 |
<tbody>
</tbody>