text to columns
 

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

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

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

Thankd. this did not work. i could not copy and paste the character . But i
found by trial and error that by selecting both tab and space you could
change the text to columns


bj wrote in message
...
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