Special characters

**dandi10** · 04-10-2012, 11:50 PM

Hello,

I have the attached file, it is showing the character code instead the special characters, this is how we import it from our vendor and then we need to upload it to our website correctly. I have a file with 2500 rows. Any one has an idea how to replace the character code for the special symbols? There are many of them.

Thank you.

**dilipandey** · 04-11-2012, 12:14 AM

Hi Dandi10,

If Excel comes in between your process of upload to website, you can use the Substitute function to remove the special characters :-

=SUBSTITUTE(A7,"&","")
=SUBSTITUTE(A7,"#","")

Regards,
DILIPandey

<click on below 'star' if this helps>

**dandi10** · 04-11-2012, 09:27 AM

Hi DILIPandey,

Thank you for the reply. What I actually need is to show these characters in the website, not to remove them. Any idea?

Thanks!

Dan.

**dilipandey** · 04-11-2012, 01:18 PM

Ok...

Any one has an idea how to replace the character code for the special symbols? There are many of them.

I was carried away with above line.. and to replace there are two widely used function apart from normal ctrl + H and that are Substitute and Replace.

Regards,
DILIPandey

<click on below 'star' if this helps>