Saving from Excel to text

  • Thread starter Thread starter Tracey
  • Start date Start date
T

Tracey

I am trying to save an excel spreadsheet as a text (tab
delimited) file but for some reason chracters are being
replaced with a '?', does anyone know why?

Any help would be greatly appreciated.
 
Tracey -

How are you saving the file? Try highlighting the
spreadsheet, copy, open Word, paste. Highlight the text
in Word, go to Tools, Table, Convert Table to Text, and
choose the Tab delimiter.

HTH,
Carole
 
In Office 2000, I can highlight my cels in Excel and Ctrl+C, then open Word
and Edit>Paste Special>Unformatted text, and it pastes in as Tab Delimited
in one easy step. 8>)

Ed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 inserts quotes when saving SS as text and comma is pres 1
convert excel to text file with no tabs 6
Save trailing empty cells in a tab delimited text file 3
Excel And Notepad 3
Missing delimiters after 15 records 3
How do I save excel file in text format without columns? 1
Text Qualifiers 1
Problem importing from access 1

Back
Top