Avoid automatic text to column split while pasting data

[Query Analyzer User]

I am copying data from Access and pasting it in Excel. The column containing
"LastName, FirstName" is automatically getting pasted in 2 columns. I want it
to get pasted in one column only.

Currently
ColA ColB
John| Doe

I need it to be
ColA

Thank you!
John, Doe

 

[Gord Dibben]

You probably used Data>Text to Columns>Delimited by "comma" for some other
operation.

Excel remembers this.........thank you much<g>

Run through Data>Text to Columns with some dummy text and change the delimiter
to nothing.


Gord Dibben MS Excel MVP

 

[reddy]

Thank you. That worked!

You probably used Data>Text to Columns>Delimited by "comma" for some other
operation.

Excel remembers this.........thank you much<g>

Run through Data>Text to Columns with some dummy text and change the delimiter
to nothing.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Thanks for the feedback.

Annoying to some(me!) little feature of Excel.....T to C remembers the last
run-through.


Gord