Html Tags for Specific Words in a Cell

J

Jaycee Sagaral

Hi Everyone,

I have problem putting up html tags to every specific word in a cell.
Let's say this praise.

JUAN: Honey, bakit MALI ang pinaglalagyan mong DALIRI ng
WEDDING RING natin?
MRS: Siyempre para TERNO! Mali din naman ang NAPANGASAWA ko eh![/
QUOTE]

The above is a conversation and I'd like to put "<b>" and "</b>" at
the beginning and end to make the talking character's name in bold
format when i uploaded it in the internet.

I target this result:

<b>JUAN</b>: Honey, bakit MALI ang pinaglalagyan mong DALIRI ng
WEDDING RING natin?
<b>MRS</b>: Siyempre para TERNO! Mali din naman ang NAPANGASAWA ko eh!

What I am thinking is replace first the : by the tag "</b>" (using
usual excel feature) then add "<b>" at the beginning of a word that
contains "</b>"

Thats the problem. How can I replace every word in a cell that
contains the "</b>". Or if there is a better idea, it will be much
appreciated.

Hope someone can help me with this. Thank you.
 
G

GS

It happens that Jaycee Sagaral formulated :
Hi Everyone,

I have problem putting up html tags to every specific word in a cell.
Let's say this praise.

JUAN: Honey, bakit MALI ang pinaglalagyan mong DALIRI ng
WEDDING RING natin?
MRS: Siyempre para TERNO! Mali din naman ang NAPANGASAWA ko eh![/
QUOTE]

The above is a conversation and I'd like to put "<b>" and "</b>" at
the beginning and end to make the talking character's name in bold
format when i uploaded it in the internet.

I target this result:

<b>JUAN</b>: Honey, bakit MALI ang pinaglalagyan mong DALIRI ng
WEDDING RING natin?
<b>MRS</b>: Siyempre para TERNO! Mali din naman ang NAPANGASAWA ko eh!

What I am thinking is replace first the : by the tag "</b>" (using
usual excel feature) then add "<b>" at the beginning of a word that
contains "</b>"

Thats the problem. How can I replace every word in a cell that
contains the "</b>". Or if there is a better idea, it will be much
appreciated.

Hope someone can help me with this. Thank you.

I suspect that, as with Word, if you bold the individual text within a
cell that you want bold then it will get the correct tags when you
export as HTML. IOW, the formatting gets tagged during the HTML
conversion process.
 
Top