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.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.577 / Virus Database: 366 - Release Date: 03/02/2004