Hi Everyone,
I have problem putting up html tags to every specific word in a cell. Let's say this praise.
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:
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 have problem putting up html tags to every specific word in a cell. Let's say this praise.
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:
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.