Transfer files to Excel

[baron]

I have 500 contacts listed in electronic text
format. How do I transfer them to an Excel
spreadsheet. Is there an easy, error free
way to do this besides copy and paste?

 

[JE McGimpsey]

I have 500 contacts listed in electronic text
format. How do I transfer them to an Excel
spreadsheet. Is there an easy, error free
way to do this besides copy and paste?

Not sure what you mean by "electronic text format" but if you have a
text file, you can use Data/Get External Data/Import Text File, and
follow the wizard...

 

[baron]

Thanks, I meant text files. I followed
your advice and used the wizard.
However once I click finish, the
files appear but it's all jumbled
across the columms. It I separate
them, words gets separated.

 

[CyberTaz]

If necessary, open the file in TextEdit & confirm what is used to separate
one column from the next. In fact, it may be better to open it in Word &
turn on the ¶ so you can better determine what was used. On the second step
of the Wizard be sure to select the appropriate Delimiter based on what Word
revealed (and remove any other checks).

If this doesn't help get it right you'll need to be more clear about what
"jumbled across the columns" & "words gets separated" means

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[little_creature]

If necessary, open the file in TextEdit & confirm what is used to separate
one column from the next. In fact, it may be better to open it in Word &
turn on the ¶ so you can better determine what was used. On the second step
of the Wizard be sure to select the appropriate Delimiter based on what Word
revealed (and remove any other checks).

If this doesn't help get it right you'll need to be more clear about what
"jumbled across the columns" & "words gets separated" means

HTH |:>)
Bob Jones
[MVP] Office:Mac

If you will find that insted of one delimiter you used more (on PC
excel usually can eat 2 different) as two spaces insted of one you can
also find/replace them in the word automatically. Do find and
replace>in the dialog click on that blue arrow and select *special*.
Pick the formating character you need to replace and do the same for
the option *replace with*.
This enables you to quicly re-format any text - such as text from
emails which usually has every row ended by paragraph mark.