Hi,

Say the cell reference of 1 is B5. In cell B10, type B5 (without the =
sign) and with the fill handle drag this to the right. When you do so, you
will get the cell references instead of values. Now select the array and
press Ctrl+H. In the Find box, type b and replacer with =b

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Mona" wrote in message
...
I see lots of post but not one I can use. I am looking for a "function"
that
will take vertical data to horizontal. I don't want the copy,paste,
transpose please.

Example :
1
2
3
Results
1 2 3

thanks!