Identify strange character

[Stuart]

I've imported a text file into Excel 2000 and I'm splitting
the data in col A.

There are 3 types of data:
1: 9 099\1\A
2: B
and on occasions a strange character that looks like a
box........that is to say _
| |
--
but the sides are all joined together.

I need to recognise this character because its location in
col A represents the start/end of a set of data.

Using IsNumeric lets me skip over the type 2 data, but I
can't find a way to trap the 'box' character.

Any ideas, please?

Regards.

 

[Frank Kabel]

Hi Stuart
one way
use the function CODE(your_cell_reference) to identify the code of this
'strange' character.
After knowing this you can use FIND to check for this charatcer or
SUBSTITUE to delete

Frank

 

[Stuart]

Thanks for that.

The problem I had was in finding the character in the first place.
I got around that by displaying an inputbox where the user could
type the address of a character, and from there I set a variable
to that cell's value.

Regards and thanks

Hi Stuart
one way
use the function CODE(your_cell_reference) to identify the code of this
'strange' character.
After knowing this you can use FIND to check for this charatcer or
SUBSTITUE to delete

Frank