Reply
 
Thread Tools Search this Thread
 
Old 23 October 2009, 04:17   #1
Member
 
Country: UK - England
Boat name: Seashell
Make: Redbay
Length: 7m +
Engine: Inboard diesel
Join Date: Jan 2004
Posts: 5,263
MS office question

I've got a plain text document containing several hundred names and addresses. I need to put it into a spreadsheet in a specific format so we can do a mail merge. Is there an easy way to do this, or am I going to have to copy and paste all the details over into their individual cells
__________________

__________________
Tim M is offline   Reply With Quote
Old 23 October 2009, 04:38   #2
Member
 
Knot Yet's Avatar
 
Country: UK - England
Town: Horsham
Boat name: Knot a RIB
Make: Avon Typhoon
Length: 4m +
Engine: Yamaha 25hp
Join Date: Sep 2009
Posts: 868
Any good - this should work if I've understood what you need to do

http://www.ehow.com/how_5073339_conv...eadsheet.html#

J
__________________

__________________
Sometimes my mind not only wanders ..... it leaves completely

Member of the ebay Blue RIB cover club.
Knot Yet is offline   Reply With Quote
Old 23 October 2009, 05:07   #3
RIBnet admin team
 
Poly's Avatar
 
Country: UK - Scotland
Boat name: imposter
Make: FunYak
Length: 3m +
Engine: 2 stroke YAM 20 HP
MMSI: 235089819
Join Date: Sep 2005
Posts: 10,114
Tim,

If Knot Yet's link doesn't help you then send me (you should be able to email me through my profile) a sample of the file (I don't need the actual data if it is sensitive - just the exact format / layout / filetype) and I will send you specific instruction for your file tonight.

NEIL
__________________
Poly is offline   Reply With Quote
Old 23 October 2009, 05:13   #4
Member
 
Country: UK - England
Boat name: Seashell
Make: Redbay
Length: 7m +
Engine: Inboard diesel
Join Date: Jan 2004
Posts: 5,263
The art of management is delegation

It's OK, got someone else to do it now

(Managed to import it all into Excel thanks to the first link, data just needs moving around now)
__________________
Tim M is offline   Reply With Quote
Old 23 October 2009, 05:36   #5
Member
 
Knot Yet's Avatar
 
Country: UK - England
Town: Horsham
Boat name: Knot a RIB
Make: Avon Typhoon
Length: 4m +
Engine: Yamaha 25hp
Join Date: Sep 2009
Posts: 868
"Nothing is impossible if you delegate" - no idea who said that but very true!!

Glad you've got it sorted
__________________
Sometimes my mind not only wanders ..... it leaves completely

Member of the ebay Blue RIB cover club.
Knot Yet is offline   Reply With Quote
Old 23 October 2009, 08:49   #6
RIBnet supporter
 
Erin's Avatar
 
Country: UK - Channel Islands
Town: A large rock
Boat name: La Frette
Make: Osprey Vipermax
Length: 6m +
Engine: 200 Suzzy
Join Date: May 2004
Posts: 2,830
If the data is comma separated then it's easy to convert it into a table in Word or move it to a spreadsheet or database automatically.
__________________
Erin is offline   Reply With Quote
Old 28 October 2009, 12:55   #7
Member
 
Country: USA
Town: Oakland CA
Length: 3m +
Join Date: Feb 2005
Posts: 6,653
Quote:
Originally Posted by Tim M View Post
It's OK, got someone else to do it now
That's the easiest way, I've found...


jky
__________________
jyasaki is offline   Reply With Quote
Old 19 November 2009, 17:20   #8
Member
 
Richard B's Avatar
 
Country: UK - England
Town: Devon
Boat name: White Ice
Make: Ranieri
Length: 5m +
Engine: Suzuki 115hp
Join Date: Jul 2002
Posts: 5,015
Quote:
Originally Posted by Erin View Post
If the data is comma separated then it's easy to convert it into a table in Word or move it to a spreadsheet or database automatically.
In fact almost any character will do as a separator - comma, tab, space..... but not A-Z or 0-9 for obvious reasons!
__________________

Richard B is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 05:26.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.