Excel 2007 : Creating complex ascII file in excel 2007

[ka2335]

Hi,

I have a collection of data in excel 2007 with 16 fields, like Name, date, Balance, total payments. I need to get all this data into a ascII file format, that follows a File Specification.

E.g Surname field must be a minimum 50 characters long. Right justified with leading spaces.

So how would i do this without having to copy and paste this whole file into Notepad and manually add spaces were required.

I can certainly use symbols instead of spaces in excel and then do a find & replace in notepad to add spaces for fields that have data which is of exact length across the whole file. E.g Business Code, which is 54 for all records in file.

I would really appreciate some help, as I am really struggling...

Thanks
Kaz

[pike]

Hiya ka2335
Weclome to the Excel Forum
you can fix the spaces like

Please Login or Register  to view this content.

[ka2335]

Thanks Pike

However i am quite a novice at Excel, so i reckon this post will be easier for me to use

http://www.mrexcel.com/forum/showthread.php?t=73409


What do you reckon?

Both do the same job right??