• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4542
  • Last Modified:

Vertical line as delimiter in Excel

I am opening a "txt" file in Excel.  The file contains vertical lines as the column delimiters.  If I set the delimiter to "other" in the Text Import Wizard, where do I find the key for the vertical line so Excel knows what the delimiter is?
Delimiter.docx
0
CynSzcz
Asked:
CynSzcz
3 Solutions
 
Saqib Husain, SyedEngineerCommented:
It is often found near the enter key coupled with the \ key. If you cannot find it then you can select that character from the cell, copy it, and then paste it in the delimiter box.
0
 
KimputerCommented:
It looks indeed like the standard keyboard key: SHIFT + \
0
 
Martin LissOlder than dirtCommented:
It's called the 'pipe' and it's ascii 166.
0
 
als315Commented:
You can always open your text file, copy delimiter and paste to Excel. In this case you can be absolutely sure in this symbol
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now