Share via

Macro to reliably concatenate bullet list phrases

Anonymous
2025-04-07T01:35:55+00:00

Hello!

I have scheduled events that get put into Word and they look like this:

  • 4 – 7pm
  • Putt-Putt in the Park
  • Little Debbie Park
  • 4 – 6pm
  • Discovery Tutors - Open Hours Downtown
  • Downtown Library, 1001 Broad Street, Chattanooga, TN, 37402, United States

etc.

There can be hundreds of these and I copy-and paste them from Google Calendar into Word every day for many years now as a long bulleted list. Since they are three lines (or sometimes two), I try and make them so they are all one line separated by commas. So:

  • 4 – 7pm, Putt-Putt in the Park, Little Debbie Park
  • 4 – 6pm, Discovery Tutors - Open Hours Downtown, Downtown Library, 1001 Broad Street, Chattanooga, TN, 37402, United States

So, I have a macro that does it now for each one (because sometimes there are two lines and sometimes three), but the cursor winds up not at the end when it is done, sometimes, it only moves some of the line, etc. If I change the font size from 12 to 8 for those longer lines, the macro works fine....??

So, put the cursor in front of "4", run macro, works fine when just a little text, cursor goes to end of line

For next one, put cursor in front of "4", run macro, when done, cursor winds up after "Chattanooga" instead of after "United States"...???

Anyway, here is the macro I'm using:

Sub Macro2()

Selection.EndKey Unit:=wdLine, Extend:=wdMove

Selection.TypeText Text:=", "

Selection.Delete Unit:=wdCharacter, Count:=1

Selection.EndKey Unit:=wdLine, Extend:=wdMove

Selection.TypeText Text:=", "

Selection.Delete Unit:=wdCharacter, Count:=1

Selection.EndKey Unit:=wdLine, Extend:=wdMove

End Sub

I appreciate your help and info.

Regards!

Microsoft 365 and Office | Install, redeem, activate | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2025-04-09T15:27:25+00:00

    Thank to this forum, I got the info I needed. Here is the macro now. :)

    Sub CombineThree()

    Selection.EndKey Unit:=wdLine, Extend:=wdMove

    Selection.TypeText Text:=", "

    Selection.Delete Unit:=wdCharacter, Count:=1

    Selection.EndKey Unit:=wdLine, Extend:=wdMove

    Selection.TypeText Text:=", "

    Selection.Delete Unit:=wdCharacter, Count:=1

    Selection.MoveDown Unit:=wdParagraph, Count:=1

    Selection.MoveLeft Unit:=wdCharacter, Count:=1

    End Sub

    :)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2025-04-07T08:06:12+00:00

    Dear JohnSmith-982

    We understand that you want to use macros to help automate the shape symbols.

    We have received the information you shared and confirmed it, but we need to explain to you:

    Problems related to macros require more professional technical information to help you solve them. We suggest that you try to seek help in Microsoft learn (English only), where there are more experts in related fields who can provide you with better solutions.

    It is designed to support advanced users like you. Many users prefer to ask questions and get more professional responses through this section.

    Here is a link to the forum where you can raise specific situations and share your ideas for solving problems.

    Word Management - Microsoft Q&A

    We will keep this issue on file in case our great volunteers come up with ideas for you.

    Best regards

    Zenobia.Z | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments No comments