• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4033
  • 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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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