Convert entity in excel

[murugavelmsc]

Hi,

I have text in the excel with the following data

A1
The Stele of Naram-Sin - coming soon! Snake Goddess or Priestess
The Column of Trajan - coming soon!

i want to convert the A1 column as
The Stele of Naram–Sin – <b>coming soon!</b>
<i>Snake Goddess</i> or <i>Priestess</i>
The Column of Trajan – </b>coming soon!</b>

Thanks in advance
Murugavel

[Bob Phillips]

What are the rules that determine what is what?