This won't convert the formulas to values.

Are you sure you're copying the formulas from B1:C1 to B###:C### before you do
the next step?

Do you have any filtering turned on?

Do you have calculation set to automatic?

DaHou wrote:

Dave- I found the bug, paste special/formulas does it.

Thanks
Dave H

"DaHou" wrote:

I have column of x,y data where A1 is an x value and A2 a y ,then A3 is an x
A4 a y etc. There are several hundred values. I'd like to be able to parse
out all the y values in the 1st column, place them in a second column, then
remove the blank cells in both columns so that the x and y data are aligned
in two separate columns.

Any tips will be greatly appreciated.
DaHou

--

Dave Peterson