| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off Text to Columns
I've used text to columns with a delimiter to import some text into excel.
The problem is that now I can't turn it off. Every time I past data it wants to apply text to columns to the pasted data. Also it does not format the text to columns the same way that I initially set it up. Any idea? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I turn off Text to Columns
Do another Text to Columns operation, but this time, uncheck or remove the
delimiter that you specified the first time. -- Hope that helps. Vergel Adriano "Blulak7" wrote: I've used text to columns with a delimiter to import some text into excel. The problem is that now I can't turn it off. Every time I past data it wants to apply text to columns to the pasted data. Also it does not format the text to columns the same way that I initially set it up. Any idea? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I turn off Text to Columns
Go to a cell and try to parse out the data again, but turn off the delimiters
that you chose the last time. That should fix it. "Blulak7" wrote: I've used text to columns with a delimiter to import some text into excel. The problem is that now I can't turn it off. Every time I past data it wants to apply text to columns to the pasted data. Also it does not format the text to columns the same way that I initially set it up. Any idea? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| turn rows into columns | Excel Discussion (Misc queries) | |||
| How to turn rows horizontally to form columns? | Excel Worksheet Functions | |||
| Turn Off Text To Columns | Excel Discussion (Misc queries) | |||
| how do I turn rows into columns | Excel Discussion (Misc queries) | |||
| turn columns into rows | Excel Discussion (Misc queries) | |||
Linear Mode
