You're welcome, Phil - thanks for feeding back.

Pete

On Sep 12, 5:20 pm, Phil Zack
wrote:
That's it Pete, problem solved!

Thanks very much.

Phil



"Pete_UK" wrote:
In the Replace panel in Word click on "More", then click on "Special"
and then choose "Manual Line Break" from the list - you will get a
funny symbol in the Replace With box, looking like ^|. In the Find
What box you want to put your semicolon.

Click Replace All, then save the file back as a text file for use in
Excel.

Hope this helps.

Pete

On Sep 12, 3:54 pm, Phil Zack
wrote:
That sounds like it will do the trick Pete, but how do I enter 'manual line
break' into the Find & Replace dialogue box? If I just press Enter, teh
cursor skips out of the box, leaving it blank. Is there some sort of machine
code for Manual Line Break?

Cheers,

Phil

"Pete_UK" wrote:
Import your text file into Word first and use Find & Replace (CTRL-H)
to replace the semicolons with a manual line break. Then save the file
as a text file again and then import it into Excel.

Hope this helps.

Pete

On Sep 12, 3:08 pm, Phil Zack <Phil
wrote:
I have a text file of several hundred email addresses, which I want to import
into Excel (or Access). The data look like:

; ; ... etc

but when I use the Import External Data wizard, it imports the whole lot as
columns in the first row, and cuts off the last few hundred, as there are
more than 255 records, so what I get looks like:

A / B /
C /
1/ / /

How can I import them as single column entries in many rows? What I want is
this:

A /
1/ /
2/ /
3/ /

Thanks in anticipation,

Phil- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -