Try copying the character and pasting it into "other" in the delimiter
definition page. A lot of times the small square indicates you don't have
the font to support that character. It could be almost any character number.

"R.VENKATARAMAN" wrote:

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