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

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 wrote:
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

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

"Frank Kabel" wrote in message
...
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 wrote:
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




---
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