Copy Specific Number of Characters From One Column to Another

[CircleG]

Hi. I need to copy a specific number of characters from one column to another. The macro needs to delete the first 11 characters and then copy up to the next 80 characters stopping at the last complete word before the 80th character. Example spreadsheet attached. Thanks for your help!

[stnkynts]

Try this:

Please Login or Register  to view this content.

[CircleG]

Thanks, stnkynts. The macro works great to move 80 characters from the primary text to the name. But is there any way to stop the copy at the last full word before the 80th character? Example of why the copy needs take only whole words: The terms ASSESS and ASSESSMENT are in the CONDITION many times and management is concerned that if we move just the 80 characters, the name will end with the 1st 3 letters of the terms.

See attached spreadsheet for a couple of examples where the name breaks mid-word. Thanks for the use of your brain.

[stnkynts]

Try this:

Please Login or Register  to view this content.

[CircleG]

The new macro is moving, not copying, the text from the Primary Text column to the Name column and is moving more than 80 characters. See attached.

The first macro did what it should except not breaking at the last full word before the 80th character.

Thanks.

[stnkynts]

It does not change or move the contents in column C when I do it. I don't know what you got going on there.
I have amended to not go beyond 80 characters to complete a word and instead short 1 word if the total length is greater than 80:

Please Login or Register  to view this content.

[CircleG]

The macro is now working perfectly. Thanks much stnkynts. Appreciate you sharing your knowledge!
I'll mark this as Solved.