importing text file data into excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When importing text file data into excel and setting delimiters there is no
option for the character that looks like this (l). Excel provides options
for comma, tab, semi-colon etc but not for that particular character, and
there is no way to insert that character in the option for other. Anyone
please help!!
 
Hi,

In my version of Excel (2003) using the import wizard you check 'Other' and
then type the delimeter you want.

Mike
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Puzzling quotes around text 2
Text-to-columns, but only 1st 2 & last delimiters 5
CSV->Excel Data Problem 1
importing from a *.txt file 4
Column Widths, Importing ANSI txt files 1
Importing Data problem 4
Importing a text file 1

Back
Top