Hi,

I Did copied & pasted a bunch of values "1,3,4,2" as it is from some website in cell S2. Now I would like that 1 to be in cell s3 , 2 in cell s4, 3 in cell s5 and 4 in cell s6 in ascending order, so that it would be possible to add, subtract and multiply those four numbers later as desired.

But the problem is that whenever i press S2 it displays the whole bunch 1,2,4,2 in the formula bar and i do not know how to proceed forward to achieve above stated result. Thus any ideas suggested will be very much appreciated.

Thank you