Adding bullets in word

I have string variable as “Opened as a sole Gold Cheque account (fee free) on 20 March 1997Converted to Awards GOLD (fee paying) on 04 January 1999Migrated to SELECT Silver (fee paying) account on 17 July 2015 Closed as Fee paying account on 27 May 2016”

I want to add this string in Word in bullets.Like this:

• Migrated to SELECT Silver (fee paying) account on 17 July 2015
• Closed as Fee paying account on 27 May 2016
• Opened as a sole Gold Cheque account (fee free) on 20 March 1997
• Converted to Awards GOLD (fee paying) on 04 January 1999

Could anyone pls help me out on this .
Thanks in advance

Hi @Amrita

Use below regular expression to separate out your string into 4 parts.

.+?(?=\d{2} [a-zA-Z]{1,10} \d{4})(\d{2} [a-zA-Z]{1,10} \d{4})

Insert it into word document and use hotkeys to add bullets to this data (select the data and press ctrl + shift + L )

2 Likes

Good day,

Can this be done using html to insert in an email message?
Thank you in advance.

You would do the same thing but at the start of each string add & #8226; which is the html code for a bullet point.

1 Like