Text to Columns Question
Thanx Ron and Pete, the courier font did it!!! I appreciate the help and
patience.
Dennis
============
In article , Ron Rosenfeld
wrote:
For formulas:
Field1: =trim(left(record,60))
Field2: =trim(mid(record,80,11))
Field3: =trim(mid(record,100,6))
and so forth.
--ron
Are you using a non-proportional font? Something like Courier or Courier New?
If the data is as you have described it, things should line up.
You can still use the formulas instead.
If the data is not how you described it, you are going to have to describe how
you can discern the dividing point between each field.
--ron
|