Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / General MS Word Questions / September 2007

Tip: Looking for answers? Try searching our database.

text file into tab-delimited file?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jeff - 28 Sep 2007 15:22 GMT
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
Beth Melton - 28 Sep 2007 18:44 GMT
Did you try opening the file in Excel? It should automatically display an
Import Wizard that accommodates comma separated values -- you shouldn't need
to convert it to a tab delimitated file first.

Also note the focus of this group is for Word related issues. For future
Excel questions the Excel newsgroups are the best place to obtain Excel
related help. :-)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Signature

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


>I have a text file (*.txt) consisting of words separated by commas.
>Example:
[quoted text clipped - 6 lines]
>
> Jeff
garfield-n-odie [MVP] - 28 Sep 2007 18:55 GMT
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.

> I have a text file (*.txt) consisting of words separated by commas.
> Example:
[quoted text clipped - 6 lines]
>
> Jeff
Suzanne S. Barnhill - 28 Sep 2007 18:55 GMT
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.

Signature

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.

> I have a text file (*.txt) consisting of words separated by commas.
> Example:
[quoted text clipped - 6 lines]
>
> Jeff
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.