View Single Post
  #3   Report Post  
Posted to microsoft.public.word.newusers
garfield-n-odie [MVP] garfield-n-odie [MVP] is offline
external usenet poster
 
Posts: 2,587
Default text file into tab-delimited file?

Not sure why you need to, because most spreadsheets will import both
comma-delimited and tab-delimited text, but yes you can. In Word 2003
or earlier, click on Edit | Replace | More. Click in the "Find what"
box, and type a comma. Click in the "Replace with" box, and click on
Special | Tab Character | Replace All.

Jeff wrote:

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