Jump to content

Microsoft Word macro to shorten characters?


Recommended Posts

Posted

I have a task that I'm doing daily, and I thought that maybe a macro could help speed things up.

On a Word document after the words "Skill:" I have to shorten the characters after the last colon by 7 characters

Is there a fast way to do this with a macro? How could I do that?

Thanks!

  • 2 weeks later...

Posted

Excel has some pretty good text trimming functions. To trim the 7 rightmost characters you could paste the texts to be trimmed into excel and then use the function

=left(Cell to be trimmed, len(Cell to be trimmed)-7)

Posted

I'd rather not have to take this into Excel and shorten the characters there. But, thanks for your suggestion. I'm looking for something I can do within Word.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...