N
Noob McKnownowt
Hi once again people,
I am having problems getting a search feature to work in excel. At present
it just matchs the exact strings passed into it, i know about the 'option
compare text' statement so it recognises lower and uppercase letters.
The problem is this, the info being searched is dragged off a mainframe and
then formated once imported to excel via a macro, this presents a problem
because large amounts of data are being moved at once it is very difficult to
remove unwanted characters.
Is there a way to build in a feature to my cade that would ignore misc
characters such as,
spaces
..
,
/
\
;
:
If these can be ignored and just the text itself in each cell is searched
this would be a massive advantage, can anyone help???
PLEASE HELP ME!!
The Noob.
I am having problems getting a search feature to work in excel. At present
it just matchs the exact strings passed into it, i know about the 'option
compare text' statement so it recognises lower and uppercase letters.
The problem is this, the info being searched is dragged off a mainframe and
then formated once imported to excel via a macro, this presents a problem
because large amounts of data are being moved at once it is very difficult to
remove unwanted characters.
Is there a way to build in a feature to my cade that would ignore misc
characters such as,
spaces
..
,
/
\
;
:
If these can be ignored and just the text itself in each cell is searched
this would be a massive advantage, can anyone help???
PLEASE HELP ME!!
The Noob.