You can use this

=SUBSTITUTE(SUBSTITUTE(UPPER(TRIM(LEFT(A3,MIN(FIND ({0,1,2,3,4,5,6,7,8,9,"("},A3&"0123456789("))-1))),"'",""),"´","")



--
Regards,

Peo Sjoblom




"Saxman" wrote in message
...
Sorry to be so thick, but do you mean typing,
CODE(MID(A2,7,1)) to find out the ASCII code of '´' and replace it with
the
the question marks (or "'") in the function below?

On 07/08/2007 14:06:00, bj wrote:
figure out where in the text it is in one example and use (for your
example) ode(mid(A2,7,1)) and replace the "'" with char(the code value)
SUBSTITUTE(UPPER(TRIM(LEFT(A2,MIN(FIND({0,1,2,3,4, 5,6,7,8,9,"("},A2&"0123456789("))-1))),char(???),"")


"Saxman" wrote:



SUBSTITUTE(UPPER(TRIM(LEFT(A2,MIN(FIND({0,1,2,3,4, 5,6,7,8,9,"("},A2&"0123456789("))-1))),"'","")

The above function which Stephanie provided me with a few days ago,
strips
all the junk in the following name for example.
Attila's Peintre (8-7) becomes Attilas Peintre

However, the actual name below when copied/pasted special from a web
page
Attila´s Peintre (8-7)
becomes:-
Attila´s Peintre (Part stripped).

As you will observe, the apostrophe remains, because there is a
difference in
the apostrophe for that particular font.

Is there a way that I can modify the above function to include '´'
rather
than '''?

I'm sure it would be a matter of a simple copy/pasting the modified
apostrophe within the function above. It looks like I would have to
modify
the end of the function, but I'm not sure how as I cannot ascertain
whether
they are quotation marks or apostrophes? There are 4 'marks' on one side
of
the comma and 5 on the other.

TIA