| delimited file

[Lovitt]

Hello,

I'm trying to open a text file and have it import right. The company
who made it said:

you should import the text file as | delimited. Not tab delimited.
When importing into Excel, and it asks you to choose your delimiter,
select other and type in | in the box to the right.

In the 2004 mac version of excel I have, it does not give me that
option, just lets me choose Delimited or Fixed width.

Does anyone have any ideas/solutions to how to import it as a |
delimited file?

Any help would be appreciated!

 

[CyberTaz]

The screen where you see the Delimited/Fixed Width choice is the *first*
step of the Import Wizard... What happens if you leave it set for
"Delimited" & then click "Next"?

 

[little_creature]

The screen where you see the Delimited/Fixed Width choice is the *first*
step of the Import Wizard... What happens if you leave it set for
"Delimited" & then click "Next"?

Hello,
As CyberTaz has indicated. I just want to confirm, that I have been
opening a lot of measured data made on PC as deliminated with
different deliminatar without problem.
Open Excel
File>open - pick your file and it should give you text import wizard,
click deliminated>next and pick your deliminator - Excel here is quite
good and allow you to pick more than one deliminator at the same time
(I had data which had space and comma as deliminator and excel was
able to eat it ) ANd than go throught the wizard. The other thing
which might blast your efford is decinal point separator, which is
hidden in the next step under the button advanced and that's it.

The same wizard should appers if you do data>text to colums. Hope this
helps. If you still have troubles, post back or send me your file so I
can have a look.

 

[Todd Aton]

Try this...

1. Open Excel
2. Select the Open command on the File menu
3. Select the file you want to open and click the Open button
4. Click the Next button in Step 1 of 3
5. Select the Other checkbox and type "|" in Step 2 of 3
6. Verify in Data Preview that the data is now in columns
7. Click the Finish button

Todd Aton
Macintosh Business Unit
Microsoft Corporation