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

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?


--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=513000

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

The way I do this is to:

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

--
Regards,
Fred


"roger_home" wrote in
message ...

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?


--
roger_home
------------------------------------------------------------------------
roger_home's Profile:
http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=513000

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

perfect...thanx so much!


--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=513000