On Dec 16, 8:42 am, Peter wrote:
When I paste the data into my spreadsheet I want it to just convert
and be done with it.

I understand. But you said "[t]here are only about 11 fractions I
need to be concerned with". I would simply dispense with cut-and-
paste in that case. But perhaps you meant to say: you are doing this
often, and there are 11 __different__ fractions each time. (And I
guess you meant to say 14 factions, not 11.)

Note: If you are doing it often, but it is always the same 14
fractions, I would simply set up a spreadsheet with the appropriate
"=fraction" formulas, and cut-and-pasteSpecial-value from there.

I use Excel 2003. If I wanted to cut-and-paste a table from a web
page, I would use either New Web Query or Import Data, both under
DataImport External Data. If either or both are available in your
version of Excel and you need help using them, post back for
instructions.

To answer your question about VLOOKUP, I would populate the table
manually, and I would use vlookup(...,false) to do the lookup. If
VLOOKUP returns #N/A, that's your clue that you need to update the
table with one or more additional fractions.

Suppose you put your table into Sheet2!A1:B14. Then if A1 (on any
other sheet) contains the first of the fractions cut-and-pasted from a
web age, B1 (on that sheet) might have the formula:

=vlookup(A1, Sheet2!A1:B14, 2, false)

If you want to eliminate the VLOOKUP formulas, you could copy them,
then use Paste SpecialValue to overwrite the text in column A.

(I put the lookup table on another sheet simply to get it out of the
way. Of course, you might choose to keep everything on the same
sheet.)

Note: I have had problems with cut-and-paste of text from web pages.
I have had to resort to pasting them into Notepad, saving the file,
then using DataImport External DataImport Data to put the desired
text into Excel. Hence my suggestion above to use one of the Import
External Data features.