Fixed field width in cells

[apv98]

Hi,

I am very new to this forum. I have two queries:

1. I have got data in various columns in a work sheet. Each colum
contains data from a table(outside excel). I want to copy all the dat
in a row to one cell. This I acheived through the formula = A1 & B1--
etc. However I want to maintain the field length of each too. Fo
example the first field in my excel file represents a field which is 2
characters long and the next 10 characters long. The data for the firs
field is abcd and for the second is 1234.

What I want in the cell is ABCD (16 character spacingin between)1234

Is it possible in excel to do this?

Thanks & regards,
Pau

 

[BrianB]

I think you can do this without any formulas.
1. Set the width of column A to 20.
2. Align the numbers column B to the left of the cells.
3. Do File/SaveAs Formatted Text (Space Delimited) *.prn
4. File/Open - open as Delimited & Finish
The text is all put into column 1.
'----------------------------------------------
Having played with that, this formula works for the example given afte
inserting a new column A :-

=B1&REPT(" ",20-LEN(B1))&C