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 !