Forums
This topic is locked
a little of topic
Posted 01 Oct 2005 07:06:30
1
has voted
01 Oct 2005 07:06:30 steve hiday posted:
ok, i have a list of over 750 email addresses that are in a word documentthey are arranged in a long list like;
ect.
ect.
my question is, how do i insert a comma after all of these addresses without actually going through and clicking and hitting comma 750 times
i want it to look like this;
,
,
,
ect.
ect.
thank you for reading this and I hope you can help me out
Replies
Replied 01 Oct 2005 13:54:36
01 Oct 2005 13:54:36 Michael Behan replied:
Find and replace! Not sure if the ms word find and replace tool can do this (find returns) but others can.
Find all "
"
and replace with ",
"
You could also try copy/pasting them into excel (or maybe you can do this in word) and exporting the list as a comma delimited CSV file... then pase back into word.
If you are doing this so you can import into a database you should be able to tell it to use returns (instead of commas) to seperate items.
Find all "
"
and replace with ",
"
You could also try copy/pasting them into excel (or maybe you can do this in word) and exporting the list as a comma delimited CSV file... then pase back into word.
If you are doing this so you can import into a database you should be able to tell it to use returns (instead of commas) to seperate items.
Replied 01 Oct 2005 18:09:37
01 Oct 2005 18:09:37 steve hiday replied:
That did not work as you said, however,
I DID FIND A SOLUTION,
using find/replace I told word to find" .com " and replace with " .com, "
did the same with .net and .org
thanks for the suggestion
I DID FIND A SOLUTION,
using find/replace I told word to find" .com " and replace with " .com, "
did the same with .net and .org
thanks for the suggestion
Replied 04 Oct 2005 01:01:45
04 Oct 2005 01:01:45 Lee Diggins replied:
Hi Steve
Lucky they all ended with .com, you could have used ^p which is the code for a paragraph mark, if I remember rightly. I usually use Excel for that kind of stuff, trim to remove spaces then concatenate function.
Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>
Lucky they all ended with .com, you could have used ^p which is the code for a paragraph mark, if I remember rightly. I usually use Excel for that kind of stuff, trim to remove spaces then concatenate function.
Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>