Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Formatting
I have a situation where we paste information into excel (from a UNIX based
system) and the data automatically delineates into separate cells. The paste formating option does not allow us to "turn off" this automatic formatting. The strange thing is this is only on 1 person's computer! On every other computer, the data copies into 1 column, and we must to the "text to columns" function - this is what we want to do. How can we get the copied text to paste into one column to do the text to columns function to organize the data as we want? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Formatting
Do not paste; import the data instead:
Data Import External Data Import Data tell the Wizard what file to import and then tell the Wizard how to parse the input. -- Gary''s Student - gsnu200802 "MSF Chrissy" wrote: I have a situation where we paste information into excel (from a UNIX based system) and the data automatically delineates into separate cells. The paste formating option does not allow us to "turn off" this automatic formatting. The strange thing is this is only on 1 person's computer! On every other computer, the data copies into 1 column, and we must to the "text to columns" function - this is what we want to do. How can we get the copied text to paste into one column to do the text to columns function to organize the data as we want? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Formatting
Thanks for the idea, but we cannot connect our system to microsoft using the
import data tool, at least not in a way that would be as easy as copying/pasting. The problem that I don't understand is that the paste function works on every other computer except one...I think it has something to do with how she has excel set up. I just want to be able to turn whatever autoformat function she has that is making the text paste incorrectly off. "Gary''s Student" wrote: Do not paste; import the data instead: Data Import External Data Import Data tell the Wizard what file to import and then tell the Wizard how to parse the input. -- Gary''s Student - gsnu200802 "MSF Chrissy" wrote: I have a situation where we paste information into excel (from a UNIX based system) and the data automatically delineates into separate cells. The paste formating option does not allow us to "turn off" this automatic formatting. The strange thing is this is only on 1 person's computer! On every other computer, the data copies into 1 column, and we must to the "text to columns" function - this is what we want to do. How can we get the copied text to paste into one column to do the text to columns function to organize the data as we want? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Formatting
Excel has a habit of remembering the last settings in DataText to Columns.
Make sure she is not set for some type of de-limiter like space. Gord Dibben MS Excel MVP On Fri, 5 Sep 2008 07:57:01 -0700, MSF Chrissy wrote: Thanks for the idea, but we cannot connect our system to microsoft using the import data tool, at least not in a way that would be as easy as copying/pasting. The problem that I don't understand is that the paste function works on every other computer except one...I think it has something to do with how she has excel set up. I just want to be able to turn whatever autoformat function she has that is making the text paste incorrectly off. "Gary''s Student" wrote: Do not paste; import the data instead: Data Import External Data Import Data tell the Wizard what file to import and then tell the Wizard how to parse the input. -- Gary''s Student - gsnu200802 "MSF Chrissy" wrote: I have a situation where we paste information into excel (from a UNIX based system) and the data automatically delineates into separate cells. The paste formating option does not allow us to "turn off" this automatic formatting. The strange thing is this is only on 1 person's computer! On every other computer, the data copies into 1 column, and we must to the "text to columns" function - this is what we want to do. How can we get the copied text to paste into one column to do the text to columns function to organize the data as we want? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Formatting
How would I check this?
"Gord Dibben" wrote: Excel has a habit of remembering the last settings in DataText to Columns. Make sure she is not set for some type of de-limiter like space. Gord Dibben MS Excel MVP On Fri, 5 Sep 2008 07:57:01 -0700, MSF Chrissy wrote: Thanks for the idea, but we cannot connect our system to microsoft using the import data tool, at least not in a way that would be as easy as copying/pasting. The problem that I don't understand is that the paste function works on every other computer except one...I think it has something to do with how she has excel set up. I just want to be able to turn whatever autoformat function she has that is making the text paste incorrectly off. "Gary''s Student" wrote: Do not paste; import the data instead: Data Import External Data Import Data tell the Wizard what file to import and then tell the Wizard how to parse the input. -- Gary''s Student - gsnu200802 "MSF Chrissy" wrote: I have a situation where we paste information into excel (from a UNIX based system) and the data automatically delineates into separate cells. The paste formating option does not allow us to "turn off" this automatic formatting. The strange thing is this is only on 1 person's computer! On every other computer, the data copies into 1 column, and we must to the "text to columns" function - this is what we want to do. How can we get the copied text to paste into one column to do the text to columns function to organize the data as we want? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Formatting
Ask her select a cell with text then go to DataText to Columns and see what
is selected as a de-limiter on second page. Clear the option boxes for comma, space and Tab so no de-limiter is selected then hit Finish Now copy the information and see what transpires. Gord On Fri, 5 Sep 2008 13:18:15 -0700, MSF Chrissy wrote: How would I check this? "Gord Dibben" wrote: Excel has a habit of remembering the last settings in DataText to Columns. Make sure she is not set for some type of de-limiter like space. Gord Dibben MS Excel MVP On Fri, 5 Sep 2008 07:57:01 -0700, MSF Chrissy wrote: Thanks for the idea, but we cannot connect our system to microsoft using the import data tool, at least not in a way that would be as easy as copying/pasting. The problem that I don't understand is that the paste function works on every other computer except one...I think it has something to do with how she has excel set up. I just want to be able to turn whatever autoformat function she has that is making the text paste incorrectly off. "Gary''s Student" wrote: Do not paste; import the data instead: Data Import External Data Import Data tell the Wizard what file to import and then tell the Wizard how to parse the input. -- Gary''s Student - gsnu200802 "MSF Chrissy" wrote: I have a situation where we paste information into excel (from a UNIX based system) and the data automatically delineates into separate cells. The paste formating option does not allow us to "turn off" this automatic formatting. The strange thing is this is only on 1 person's computer! On every other computer, the data copies into 1 column, and we must to the "text to columns" function - this is what we want to do. How can we get the copied text to paste into one column to do the text to columns function to organize the data as we want? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA paste with formatting? | Excel Discussion (Misc queries) | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
Excel paste formatting | Excel Worksheet Functions | |||
paste cell with formatting | Excel Discussion (Misc queries) | |||
Formatting not retained using paste all and paste link | Excel Worksheet Functions |