to right justify
=rept(" ",10-len(trim(a1)))&trim(a1)&rept(" ",10-len(trim(b1))) & trim(B1)

to left justify
=trim(a1)&rept(" ",10-len(trim(a1)))&trim(B1)&rept(" ",10-len(trim(b1)))

--
Regards,
Tom Ogilvy


"apv98 " wrote in message
...
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 column
contains data from a table(outside excel). I want to copy all the data
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. For
example the first field in my excel file represents a field which is 20
characters long and the next 10 characters long. The data for the first
field is abcd and for the second is 1234.

What I want in the cell is ABCD 1234

Is it possible in excel to do this?

Thanks & regards,
Paul


---
Message posted from http://www.ExcelForum.com/