Hi,

You can remove characters from a string by using the replace function

Msgbox Replace("checking for the ' character","'","")

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"NateBuckley" wrote in message
...
Hello is it possible to go through a String checking for certain
characters?

Basically want to somehow convert a String to a character array and go
through it checking for the ' character. Or failing that, is there a
function
that disposes of certain characters within a string.

Cheers.

Nate