I think Excel can import comma-separated files, but you can replace the
commas with tabs easily enough. Type a comma and a space in the "Find what"
box of the Find and Replace dialog and ^t in the "Replace with" box. Then
Replace All. You'll have to save as a Word doc, though, to preserve the
formatting. You can then copy/paste the text into Excel, or you can use
Table | Convert | Text to Table to convert it to a table before
copy/pasting.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site:
http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"Jeff" wrote in message
...
I have a text file (*.txt) consisting of words separated by commas.
Example:
Smith (324), Andrews (512), Henry (112), .... etc.
Is there an easy way to convert this into a tab delimited file I can
import into a spreadsheet?
Thank you.
Jeff