ExcelBanter - vlookup - removing formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - vlookup - removing formulas (https://www.excelbanter.com/excel-discussion-misc-queries/166352-vlookup-removing-formulas.html)

Megan

vlookup - removing formulas

I have used a vlookup to transfer data from spr 1 to spr 2. The problem is
that I want to now remove the VLOOKUP formulas from spr 2 so I am just left
with the data. How can I do this?
--
Kind regards
Megan

pinmaster

vlookup - removing formulas

Hi,

copy then paste special, values

Regards!
Jean-Guy

"Megan" wrote:

I have used a vlookup to transfer data from spr 1 to spr 2. The problem is
that I want to now remove the VLOOKUP formulas from spr 2 so I am just left
with the data. How can I do this?
--
Kind regards
Megan

All times are GMT +1. The time now is 05:31 AM.