importing text file data into excel

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!!
 
G

Guest

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

CSV->Excel Data Problem 1
Text-to-columns, but only 1st 2 & last delimiters 5
char 124 where is on my keyboard. 9
The @ symbol 7
How do I change text qualifier from double quote? 1
Files saved as csv files are actually saved as text files? 4
Retain Numbers as Text Format When Importing. 2
Stopping conversion to an elipse character 1

Top