Microsoft Word – Find and replace ", " with a return

I had a user who had a long list of email addresses which were separated by a coma, looking a little something like this:

emailaddress@email.com, emailaddress@email.com, emailaddress@email.com, emailaddress@email.com, emailaddress@email.com, emailaddress@email.com, emailaddress@email.com, emailaddress@email.com, emailaddress@email.com,
The user wanted the list to appear as a list:
emailaddress@email.com
emailaddress@email.com
emailaddress@email.com
emailaddress@email.com
emailaddress@email.com
and wanted to know the quickest way to do it. I suggest using the find and replace function. In this example I am using Microsoft Word.
I copied the list of email addresses into Word in the format much like the first example. After doing so I then went to:
Edit > Replace
You will then be presented with the “Find and Replace” dialogue box. Here I then used the following criteria:
Find what: , [include the space]
Replace with: ^p
^p is the code for Paragraph Mark. You can type this in manually or it can be found under:
Special > Paragraph Mark
You can now run a Replace to test that the command is functioning correctly and then Replace All.
Advertisements

About OngoingIssues

Ongoing Issues, bringing you a selection of the latest Tech News across all platforms, software and hardware that we find interesting.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: