Hi,

You don't need a formula. Copy the numbers then select a cell 'outside' of
the range and then 'Paste Special' select Transpose OK

PS I think the Caps lock key on your keyboard is stuck.

Mike

"AMIT BHOPAL" wrote:

WE HAVE VERTICAL LINE OF NUMBER AND WE WANT TO CONVERT IN HORIZONTAL LINE.PLEASE GIVE SHORT CUT FORMULA

EXT:

1
2
3
4
5
6
7
8
9
10

Please convert in horizontal line.



Submitted via EggHeadCafe - Software Developer Portal of Choice
Pure Javascript Martin Browser Fractals
http://www.eggheadcafe.com/tutorials...martin-br.aspx
.