Excel2003 ...

WS1 ... Row Range L2:Z2 ... Contains Text

WS2 ... Col Range B3:B17 ... I wish formula to populate Text from WS1

== I know I can do this with Copy/Paste/Special/Transpose ... However, I
wish a Formula to do it as I need to apply in additional places ...

Thanks ... Kha