View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dennis
 
Posts: n/a
Default 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