View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gavin Gavin is offline
external usenet poster
 
Posts: 21
Default Converting from Excel into a fixed length record

A simplified example of what I need to do.

I have the following cells in Excel A1=xxx, A2=yyyyy and A3=zzzzz
which I need to convert in a fixed length record with offsets of 0, 5 & 13
so that it looks like this "xxx yyyyy zzzzz"

If the field is a numeric I can use custom option to format the field to the
appropriate no. of characters but how do I do this for an alpha field ?