hi
why not copy the data and paste special transposed.
on the menu bar...
editpaste specialcheck transposeok

or do you just have to have a formula. i don't think you can do it with a
single formula.

Regards
FSt1

"Ken" wrote:

Excel2003 ...

WorkSheet 1 ... Col Range A2:A10 (my range larger, but this will do)

contains "Text" (numbers which may have leading 0's fomatted as Text)

WorkSheet 2 ... Row Range A2:I2

I wish Formula in WS2 Row Range to = WS1 Col Range? I can do this, but not
looking to do it 1 cell @ a time ... Is there an easier way?

ie:

WS2 Cell A2 = WS1 Cell A2
WS2 Cell B2 = WS1 Cell A3
WS2 Cell C2 = WS1 Cell A4
etc.

Thanks ... Kha