convert special charatters

[macro001]

Hi
I have some data with special charatters like this:
all& # 039;
(without spaces)

I like to convert this in
all'

how do this?
thx

 

[macro001]

decio look my file with my string
Arval Mascara Volumizzante Resistente all&# 039; Acqua 9 ml nero
https://www.sendspace.com/file/wcxhbb
not work

 

[deciog]

Macro001


All has the same character or is varial, shows more examples


Decio

 

[nithin shettigar]

=MID(D5,SEARCH("all"&"*",D5,1),SEARCH(";",D5,1)+1-SEARCH("all"&"*",D5,1))

 

[macro001]

Macro001


All has the same character or is varial, shows more examples


Decio

varial

 

[macro001]

i not know how many row have this problem
i have 15 thounsend rows

i can have :

‘		‘	left single quote
’		’	right single quote
‚		‚	single low-9 quote
“		“	left double quote
”		”	right double quote
„		„	double low-9 quote
†		†	dagger
‡		‡	double dagger
‰		‰	per mill sign
‹		‹	single left-pointing angle quote
›		›	single right-pointing angle quote
♠		♠	black spade suit
♣		♣	black club suit
♥

<tbody>
</tbody>

or more and more


grrrrrr if i paste here the code, automati c convert in symbol!!
[FONT=Exchange SSm 4r, ExchangeWeb-Roman, Georgia, serif] i can have all this symbol

[/FONT]https://www.wired.com/2010/02/special_characters/

 

[macro001]

 

[mikerickson]

I downloaded your file and it lookes like the formula in post #7 will work for you, once the cell address is changed to match your situation.

 

[macro001]

I downloaded your file and it lookes like the formula in post #7 will work for you, once the cell address is changed to match your situation.

i have try your formula
=IFERROR(REPLACE(A1,FIND("&#",A1),6,CHAR(MID(A1,FIND("&#",A1)+2,3))), A1&"")
not work

 

[deciog]

macro001

Sorry, post more examples with other special characters, to make the right formula

Decio

 

[macro001]

macro001

Sorry, post more examples with other special characters, to make the right formula

Decio

i put the code with a ""
this code is without space
i must put space becouse here in forum convert to a symbol and you can't see the code

Dolce"& amp;"Gabbana Dolce eau de parfum 30 ml spray Arval Mascara Volumizzante Resistente all"& #039;" Acqua 9 ml nero Alyssa Ashley Musk Golden Glitter Hand "& amp;" Body Moisturiser 250 ml Alyssa Ashley Vanilla Bath "& amp;" Shower Gel 300 ml <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

Athena"& #039;"s AloeBio50 Detergente Fluido extra-comfort 250 ml

<tbody>
</tbody>