Hi all,

On a form there are 3 rows consisting of 5 controls each row. After
inputting, these contents of the controls should also be aligned up neatly in
a merged range cell in the following format:

Row1Field1 Row1Field2 Row1Field3 Row1Field4 Row1Field5
Row2Field1 Row2Field2 Row2Field3 Row2Field4 Row2Field5
Row3Field1 Row3Field2 Row3Field3 Row3Field4 Row3Field5

I can use space() to make each column have same number of character, but
because each char'width is different, for example "1" and "w", so there is
still some
position shift. How can I overcome it?

Clara

--
thank you so much for your help