View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MSF Chrissy[_2_] MSF Chrissy[_2_] is offline
external usenet poster
 
Posts: 2
Default 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?