Try other, hold down the alt key and type 010 on the numpad, release the alt
key
I have never heard of char 1 as delimiter, sometimes char 10 and char 13
(alt + 013)

--
Regards,

Peo Sjoblom

(No private emails please)


"R.VENKATARAMAN" wrote in message
...
sometimes i get a text from a webpage with delimiters a small square (what
you get when you type =char(1) in an excel cell). how to specify this
delimiter in the <data-texttocolumn. Fixed width criterion does not
help.
thanks regards
mine excel 2000
windows 98
--
remove $$$ from email addresss to send email