VLOOKUP question...it probably can't...

R

roger_home

I have a VLOOKUP that works fine, but I usually find that after it comes
into my file, I need to change something based on whatever I'm using it
for at the time (some words deleted or added)...is there any way that
once the text comes in, it drops the "VLOOKUP" string and just becomes
text that I can add or delete to?
 
F

Fred Smith

The way I do this is to:

1. Copy the cell
2. Right click and select Paste Special...
3. Choose Values
 
Top