Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns - Excel 97
We have a number of staff still using Excel 97. When they download a file
from a website, the data for some users appears in one column and they are required to use the text to column function to separate the data. However, for other users it will automatically separate the data into columns on download. Can someone please explain if there is a setting that will allow for data to be automatically separated in columns on download. I can't seem to work out why only some users are affected. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns - Excel 97
Excel (at least more recent versions) tends to have a memory of the text to
columns options. Go into Data/ Text to Columns/ Delimiter, and set the delimiter to what would be appropriate for your file. Then try to open your file. -- David Biddulph "Monk" wrote in message ... We have a number of staff still using Excel 97. When they download a file from a website, the data for some users appears in one column and they are required to use the text to column function to separate the data. However, for other users it will automatically separate the data into columns on download. Can someone please explain if there is a setting that will allow for data to be automatically separated in columns on download. I can't seem to work out why only some users are affected. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns - Excel 97
Thanks David. Doesn't seem to memorise. It defaults back to fixed width. I
might have to use a macro unless you can suggest something else. "David Biddulph" wrote: Excel (at least more recent versions) tends to have a memory of the text to columns options. Go into Data/ Text to Columns/ Delimiter, and set the delimiter to what would be appropriate for your file. Then try to open your file. -- David Biddulph "Monk" wrote in message ... We have a number of staff still using Excel 97. When they download a file from a website, the data for some users appears in one column and they are required to use the text to column function to separate the data. However, for other users it will automatically separate the data into columns on download. Can someone please explain if there is a setting that will allow for data to be automatically separated in columns on download. I can't seem to work out why only some users are affected. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
Excel text to columns | Excel Discussion (Misc queries) | |||
Linking text columns with text and data columns | Excel Worksheet Functions | |||
add text of 2 columns in Excel A+B=AB | Excel Worksheet Functions |