P
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 !
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 !