Sylgeox, copy, edit, paste special, check valves. If you don't want to write
over your data, pick another place to paste the data then edit, paste
special, check valves

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sylgeox" wrote in message
...
I want to sort a column of character variables which have been computed by
a
formula. The formula is VLOOKUP(....._). The standard sort routine does
not
work because each cell contains the fomula used to arrive at the variable
rather than the variable itself. Is there a way I can copy the column and
retain the actual entries rather than the formula?