Macro Word: Replace [Comma] with [Line Break]

Solved
Anonymous user -  
C-Claire Posted messages 4562 Registration date   Status Membre Last intervention   -
Hello,

I managed to create an automatic list through Google Docs using forms.
When I export the form results in Word format, my computer gives me a list like this:

ID card, Passport, Driver's license, ID photos (for the package), Tickets (plane + train + boat + bus...) round trip, Addresses of accommodation

What I want is for Word to replace the "comma" characters with a "line break + bullet point" to give this:

- ID card
- Passport
- Driver's license
- ID photos (for the package)
- Tickets (plane + train + boat + bus...) round trip
- Addresses of accommodation


This will allow me to create pre-made lists, where once the items to buy/do/pack are on it, I just have to print it out to make my personal checklist.

Best regards
--
Before, I was D*ck. But that was before; at least I hope so :D
Self-deprecation LOL XXL

2 réponses

Anonymous user
 
Ah that's good. I remember ...

You need to go to Find and Replace.
Put "," in the find box and "^p" in the replace box.

It should also be doable with a macro, so I’ll leave the topic open, dear friends

--
Before, I was C*n. But that was before; at least I hope so :D
Self-deprecation LOL XXL
9
C-Claire Posted messages 4562 Registration date   Status Membre Last intervention   2 250
 
Hello,

- press CTRL H to display the Find/Replace dialog box
- type the comma in the "Find" field.
- type or better yet, copy/paste what is in quotes "^p- " in the "Replace with" field (note the space after the -).
- click on "Replace All".

--
C-Claire
5