I'm using a vlookup formula where the user enters a single digit in a cell in
one column, and text shows up in the adjacent cell in the next column.

i.e. typing 2 in column E causes column F to read 'medical leave of absense'

Is there a way to copy the text 'medical leave of absense' in column F into
another file?

this 2nd file is emailed to someone else, I don't want formulas, just text
to show up in this file

On Mon, 18 Jul 2005 10:19:04 -0700, "carrera"
wrote:

I'm using a vlookup formula where the user enters a single digit in a cell in
one column, and text shows up in the adjacent cell in the next column.

i.e. typing 2 in column E causes column F to read 'medical leave of absense'

Is there a way to copy the text 'medical leave of absense' in column F into
another file?

this 2nd file is emailed to someone else, I don't want formulas, just text
to show up in this file

Before you email it, select the formulas, copy, then:
Edit -- Paste Special
Select Values and click OK

MP
--
"Learning is a behavior that results from consequences."
B.F. Skinner