I am distributing fields from a fixed-length input text file across cells in Excel via the TextToColumns method. Some values contain leading spaces that must be retained but appear to be dropped by the method. I don't want to put delimiters in the input file. Is there a way to retain leading spaces with this method, or is some other technique available? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Keep leading spaces in Excel
- Thread starter tkupfer
- Start date
SkipVought
Programmer
Hi,
If you use fixed length, the parser will drop leading spaces.
If you use a delimiter, the spaces will be retained.
Skip,
Skip@TheOfficeExperts.com
If you use fixed length, the parser will drop leading spaces.
If you use a delimiter, the spaces will be retained.
Skip,
Skip@TheOfficeExperts.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
