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 quot;VLOOKUPquot; string and just becomes
text that I can add or delete to?--
roger_home
------------------------------------------------------------------------
roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
View this thread: www.excelforum.com/showthread...hreadid=513000The way I do this is to:
1. Copy the cell
2. Right click and select Paste Special...
3. Choose Values
--
Regards,
Fredquot;roger_homequot; gt; wrote in
message ...
gt;
gt; I have a VLOOKUP that works fine, but I usually find that after it comes
gt; into my file, I need to change something based on whatever I'm using it
gt; for at the time (some words deleted or added)...is there any way that
gt; once the text comes in, it drops the quot;VLOOKUPquot; string and just becomes
gt; text that I can add or delete to?
gt;
gt;
gt; --
gt; roger_home
gt; ------------------------------------------------------------------------
gt; roger_home's Profile:
gt; www.excelforum.com/member.php...oamp;userid=16434
gt; View this thread: www.excelforum.com/showthread...hreadid=513000
gt;
perfect...thanx so much!--
roger_home
------------------------------------------------------------------------
roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
View this thread: www.excelforum.com/showthread...hreadid=513000
- Nov 03 Mon 2008 20:47
VLOOKUP question...it probably can't...
close
全站熱搜
留言列表
發表留言
留言列表

