MS office question

[Tim M]

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

[Knot Yet]

Any good - this should work if I've understood what you need to do

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

J

[Polwart]

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

[Tim M]

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)

[Knot Yet]

"Nothing is impossible if you delegate" - no idea who said that but very true!!

Glad you've got it sorted

[Erin]

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.

[jyasaki]

Originally Posted by Tim M

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

That's the easiest way, I've found...


jky

[Richard B]

Originally Posted by Erin

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!