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?

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?

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?

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?

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?

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?