Convert formula imnto values

[Peter]

Hi,

In a column of my spreadsheet there are only VLOOKUP functions, all working properly.

But now I want to replace that function, with the value found by that VLOOKUP function.

I found something like doube click (in-cell editing) and then F9, but that only works for one cell
at a time.

Anyone who has any idea how to do that for a complete column or maybe complete spreadsheet.

I expected a simple menu in Excel like "Convert formula into value", but that seems to be missing.

Some help would be nice.

Thanks !

 

[Rusty]

Hi,

In a column of my spreadsheet there are only VLOOKUP functions, all
working properly.

But now I want to replace that function, with the value found by that
VLOOKUP function.

I found something like doube click (in-cell editing) and then F9, but that
only works for one cell at a time.

Anyone who has any idea how to do that for a complete column or maybe
complete spreadsheet.

I expected a simple menu in Excel like "Convert formula into value", but
that seems to be missing.

Some help would be nice.

Thanks !

Highlight the cells, copy, paste special, values.

Cheers,
Ken

 

[Pete_UK]

Highlight the column with the formulae in and click <copy>. Then click
Edit | Paste Special | Values (check) then OK followed by <Esc>.

Hope this helps.

Pete