?
Solved

Vertical line as delimiter in Excel

Posted on 2014-04-19
5
Medium Priority
?
3,169 Views
Last Modified: 2014-05-05
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
Comment
Question by:CynSzcz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 668 total points
ID: 40010738
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
 
LVL 36

Assisted Solution

by:Kimputer
Kimputer earned 668 total points
ID: 40010776
It looks indeed like the standard keyboard key: SHIFT + \
0
 
LVL 48

Assisted Solution

by:Martin Liss
Martin Liss earned 664 total points
ID: 40010780
It's called the 'pipe' and it's ascii 166.
0
 
LVL 40

Expert Comment

by:als315
ID: 40011007
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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question