poker news
blondepedia
card room
tournament schedule
uk results
galleries
Welcome,
Guest
. Please
login
or
register
.
June 14, 2024, 02:55:08 PM
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Search:
Advanced search
Order through Amazon and help blonde Poker
2273021
Posts in
66760
Topics by
16723
Members
Latest Member:
callpri
blonde poker forum
Community Forums
The Lounge
Microsoft Word Experts Please
0 Members and 1 Guest are viewing this topic.
« previous
next »
Pages:
[
1
]
Author
Topic: Microsoft Word Experts Please (Read 1485 times)
DaveShoelace
Hero Member
Offline
Posts: 9168
Microsoft Word Experts Please
«
on:
May 05, 2011, 03:00:16 PM »
Afternoon All,
I have a word document that has hundreds of email addresses on it, many of which are repeated several times. I want to find a way of locating the email addresses which are duplicated so I can delete them so I don't send emails twice.
Anyone got any clue how I can do this? I know how to look for specific words that have been duplicated, but not when I don't know what is potentially being duplicate (if that makes sense).
cheers
Logged
millidonk
Hero Member
Offline
Posts: 9140
I'm supposed to wear a shell.. I don't - SLUG LIFE
Re: Microsoft Word Experts Please
«
Reply #1 on:
May 05, 2011, 03:01:20 PM »
Quote from: DaveShoelace on May 05, 2011, 03:00:16 PM
Afternoon All,
I have a word document that has hundreds of email addresses on it, many of which are repeated several times. I want to find a way of locating the email addresses which are duplicated so I can delete them so I don't send emails twice.
Anyone got any clue how I can do this? I know how to look for specific words that have been duplicated, but not when I don't know what is potentially being duplicate (if that makes sense).
cheers
Copy and paste into excel and hit the remove duplicate button, then copy back into word
Logged
WC2014 WOTN:
http://1drv.ms/1s7Bcqh
Get rich like a N!T:
http://sdrv.ms/RDOMxQ
http://twitter.com/BigDaveMilligan
outragous76
Hero Member
Offline
Posts: 13363
Yeah Bitch! ......... MAGNETS! owwwh!
Re: Microsoft Word Experts Please
«
Reply #2 on:
May 05, 2011, 03:19:51 PM »
paste the address into "find" feature - keep hittting find next then delete
you will be done in no time
Logged
".....and then I spent 2 hours talking with Stu which blew my mind.........."
millidonk
Hero Member
Offline
Posts: 9140
I'm supposed to wear a shell.. I don't - SLUG LIFE
Re: Microsoft Word Experts Please
«
Reply #3 on:
May 05, 2011, 03:22:49 PM »
Quote from: outragous76 on May 05, 2011, 03:19:51 PM
paste the address into "find" feature - keep hittting find next then delete
you will be done in no time
I had a file with 19,000 email addresses earlier today. ^^^ method would hurt/poss kill me. But if you only have a few then it might be worth while.
Logged
WC2014 WOTN:
http://1drv.ms/1s7Bcqh
Get rich like a N!T:
http://sdrv.ms/RDOMxQ
http://twitter.com/BigDaveMilligan
outragous76
Hero Member
Offline
Posts: 13363
Yeah Bitch! ......... MAGNETS! owwwh!
Re: Microsoft Word Experts Please
«
Reply #4 on:
May 05, 2011, 03:28:31 PM »
Quote from: milligan84 on May 05, 2011, 03:22:49 PM
Quote from: outragous76 on May 05, 2011, 03:19:51 PM
paste the address into "find" feature - keep hittting find next then delete
you will be done in no time
I had a file with 19,000 email addresses earlier today. ^^^ method would hurt/poss kill me. But if you only have a few then it might be worth while.
yes dont do this if you have 19,000 addys!
Logged
".....and then I spent 2 hours talking with Stu which blew my mind.........."
DaveShoelace
Hero Member
Offline
Posts: 9168
Re: Microsoft Word Experts Please
«
Reply #5 on:
May 05, 2011, 03:59:33 PM »
Quote from: outragous76 on May 05, 2011, 03:28:31 PM
Quote from: milligan84 on May 05, 2011, 03:22:49 PM
Quote from: outragous76 on May 05, 2011, 03:19:51 PM
paste the address into "find" feature - keep hittting find next then delete
you will be done in no time
I had a file with 19,000 email addresses earlier today. ^^^ method would hurt/poss kill me. But if you only have a few then it might be worth while.
yes dont do this if you have 19,000 addys!
I actually had about 2000, but I spent the last hour putting each one on a seperate line of word then c&p into excel as milligan suggested - worked a treat, thanks one and all
Logged
millidonk
Hero Member
Offline
Posts: 9140
I'm supposed to wear a shell.. I don't - SLUG LIFE
Re: Microsoft Word Experts Please
«
Reply #6 on:
May 05, 2011, 05:15:34 PM »
A geeky tip for ya, if ever in the same boat again and you fancy saving yourself an hour or so messing about in word. Select all the text in word, copy into a text pad, save it, go to excel, open the txt file within excel and it will give you the option something along the lines of delimited text file, seperated by tabs, commas or spaces, hit ok and this will sort it out for you all nice and neat in seconds then you can dedupe the lot. Have fun.
Logged
WC2014 WOTN:
http://1drv.ms/1s7Bcqh
Get rich like a N!T:
http://sdrv.ms/RDOMxQ
http://twitter.com/BigDaveMilligan
Pawprint
Hero Member
Offline
Posts: 1055
Re: Microsoft Word Experts Please
«
Reply #7 on:
May 05, 2011, 06:42:53 PM »
Quote from: milligan84 on May 05, 2011, 05:15:34 PM
A geeky tip for ya, if ever in the same boat again and you fancy saving yourself an hour or so messing about in word. Select all the text in word, copy into a text pad, save it, go to excel, open the txt file within excel and it will give you the option something along the lines of delimited text file, seperated by tabs, commas or spaces, hit ok and this will sort it out for you all nice and neat in seconds then you can dedupe the lot. Have fun.
What he said
Logged
www.apat.com
Jon MW
Hero Member
Offline
Posts: 6193
Re: Microsoft Word Experts Please
«
Reply #8 on:
May 05, 2011, 07:11:03 PM »
What he said - except you can usually just copy and paste straight from Word into Excel
If it doesn't sort it straight out away then 'text to columns' is the function you need to use - and if that doesn't work it out then saving it as a text file and opening it wouldn't either.
Logged
Jon "the British cowboy" Woodfield
2011 blonde MTT League August Champion
2011 UK Team Championships: Black Belt Poker Team Captain - - runners up - -
5 Star HORSE Classic - 2007 Razz Champion
2007 WSOP Razz - 13/341
h
Hero Member
Offline
Posts: 1452
Re: Microsoft Word Experts Please
«
Reply #9 on:
May 05, 2011, 08:12:20 PM »
Quote from: Jon MW on May 05, 2011, 07:11:03 PM
What he said - except you can usually just copy and paste straight from Word into Excel
If it doesn't sort it straight out away then 'text to columns' is the function you need to use - and if that doesn't work it out then saving it as a text file and opening it wouldn't either.
think the point of putting into note pad is abilty to save file as csv
which when you then open in excel use text to colum with qaulifier of comma
if it was me would keep all data in excel and mail merge into word when required makes editing must easier
Logged
RED-DOG
International Lover World Wide Playboy
Global Moderator
Hero Member
Offline
Posts: 47025
Re: Microsoft Word Experts Please
«
Reply #10 on:
May 05, 2011, 08:55:11 PM »
Have you tried turning it off and on?
Logged
The older I get, the better I was.
Jon MW
Hero Member
Offline
Posts: 6193
Re: Microsoft Word Experts Please
«
Reply #11 on:
May 05, 2011, 08:59:19 PM »
Quote from: h on May 05, 2011, 08:12:20 PM
Quote from: Jon MW on May 05, 2011, 07:11:03 PM
What he said - except you can usually just copy and paste straight from Word into Excel
If it doesn't sort it straight out away then 'text to columns' is the function you need to use - and if that doesn't work it out then saving it as a text file and opening it wouldn't either.
think the point of putting into note pad is abilty to save file as csv
which when you then open in excel use text to colum with qaulifier of comma
if it was me would keep all data in excel and mail merge into word when required makes editing must easier
I guessed that - I was saying it wasn't necessary, you can just paste it into excel instead of notepad and cut out the middle step.
But agreed, I would usually tend to have it in excel to start with anyway.
Logged
Jon "the British cowboy" Woodfield
2011 blonde MTT League August Champion
2011 UK Team Championships: Black Belt Poker Team Captain - - runners up - -
5 Star HORSE Classic - 2007 Razz Champion
2007 WSOP Razz - 13/341
doubleup
Hero Member
Offline
Posts: 7066
Re: Microsoft Word Experts Please
«
Reply #12 on:
May 06, 2011, 08:04:12 PM »
Since when did spammers care about sending their spam out twice?
Logged
Pages:
[
1
]
« previous
next »
Jump to:
Please select a destination:
-----------------------------
Poker Forums
-----------------------------
=> The Rail
===> past blonde Bashes
===> Best of blonde
=> Diaries and Blogs
=> Live Tournament Updates
=> Live poker
===> Live Tournament Staking
=> Internet Poker
===> Online Tournament Staking
=> Poker Hand Analysis
===> Learning Centre
-----------------------------
Community Forums
-----------------------------
=> The Lounge
=> Betting Tips and Sport Discussion
Loading...