Avoid automatic text to column split while pasting data

  • Thread starter Thread starter Query Analyzer User
  • Start date Start date
Q

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
 
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
 
Thank you. That worked!

Gord Dibben said:
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
Click to expand...
 
Thanks for the feedback.

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


Gord
 
Back
Top