You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語Import » Insert text file separated by "|" (pipe/bar)...
This utility inserts a pipe (|) delimited text file into your worksheet at the position of your active cell.From Wikipedia: Although not as common as commas or tabs, the vertical bar can be used as a delimiter in a text file. The symbol "|" has various names.
Source: http://en.wikipedia.org/wiki/Vertical_bar
Starting this utility
In the Excel menu choose: ASAP Utilities » Import » Insert text file separated by "|" (pipe/bar)...« Return to the list of “Import” tools.
| « Previous Insert text file separated by comma (csv file)... | Next » Insert text file separated by "!" (exclamation mark)... |
You can do this too
Download "The one essential add-in for all Excel users."
Additional keywords for this tool:
import, bar, Sheffer stroke, pipe, vertical bar, verti-bar, vbar, vertical line, pipeline, piped, textfile
import, bar, Sheffer stroke, pipe, vertical bar, verti-bar, vbar, vertical line, pipeline, piped, textfile
© 1999-2022 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
