M
mark.wolven
Currently, the data set that I am working with isn't all that large.
But, I expect the data sets to grow.
That said, what I would like to be able to do, would be to execute a
function that searches for special characters. It' doesn't have to
replace them, all I'd need is a TRUE FALSE answer to the question, is
there a special character in this cell. Then I could use that formula
to flag the cells that need to be cleaned up before they are imported.
Also, is there a way to identify a low value character in a specified
position in a cell. I am also trying to identify cells that begin with
a space, paren, underscore, etc.
Any thoughts on one or both of these would be grrrreatly appreciated.
But, I expect the data sets to grow.
That said, what I would like to be able to do, would be to execute a
function that searches for special characters. It' doesn't have to
replace them, all I'd need is a TRUE FALSE answer to the question, is
there a special character in this cell. Then I could use that formula
to flag the cells that need to be cleaned up before they are imported.
Also, is there a way to identify a low value character in a specified
position in a cell. I am also trying to identify cells that begin with
a space, paren, underscore, etc.
Any thoughts on one or both of these would be grrrreatly appreciated.