| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Text to Columns - moves text up | Excel Discussion (Misc queries) | |||
| Text To Columns | Excel Worksheet Functions | |||
| How do I compare two columns on seperate sheets and replace text . | Excel Worksheet Functions | |||
Linear Mode
