D
Deleted member 6694
Guest
I've got some partial HTML code within an Excel cell and it showing the special character codes rather than the readable characters. Here is an example I.
THIS IS A 12" RECORD FROM THE 80's
It should say THIS IS A 12" RECORD FROM THE 80's but the " and ' are showing as " and ' within the cell instead!
Here's the list of the codes and what characters they correspond to.
Is there any quick fix such as a function that allows you to use something like CHAR(34) which would convert and show the " and ' within the cell?
Worst case is I could just create a macro to do a find/replace for certain special characters but surely there's an easier way?
Basically I'm looking to format the fucker
THIS IS A 12" RECORD FROM THE 80's
It should say THIS IS A 12" RECORD FROM THE 80's but the " and ' are showing as " and ' within the cell instead!
Here's the list of the codes and what characters they correspond to.
Special Characters
To make special characters and accented letters show up on your pages, use a special set of codes called character entities, which you insert into your HTML code and which your browser will display as the corresponding symbols or characters you want. The most common character entities have been...
www.wired.com
Is there any quick fix such as a function that allows you to use something like CHAR(34) which would convert and show the " and ' within the cell?
Worst case is I could just create a macro to do a find/replace for certain special characters but surely there's an easier way?
Basically I'm looking to format the fucker
haha, stupid edit has quoted meI've got some partial HTML code within an Excel cell and it showing the special character codes rather than the readable characters. Here is an example I've made up.
THIS IS A 12" RECORD FROM THE 80's
It should say THIS IS A 12" RECORD FROM THE 80's but the " and ' are showing as " and ' within the cell instead!
Here's the list of the codes and what characters they correspond to.
Special Characters
To make special characters and accented letters show up on your pages, use a special set of codes called character entities, which you insert into your HTML code and which your browser will display as the corresponding symbols or characters you want. The most common character entities have been...www.wired.com
Is there any quick fix such as a function that allows you to use something like CHAR(34) which would convert and show the " and ' within the cell?
Worst case is I could just create a macro to do a find/replace for certain special characters but surely there's an easier way?
Basically I'm looking to format the fucker
Last edited by a moderator: