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

On Wed, 25 Jun 2008 09:41:00 -0700, Query Analyzer User
<(E-Mail Removed)> wrote:

>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

Thank you. That worked!

"Gord Dibben" wrote:

> 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
>
> On Wed, 25 Jun 2008 09:41:00 -0700, Query Analyzer User
> <(E-Mail Removed)> wrote:
>
> >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
>
>

Thanks for the feedback.

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


Gord

On Thu, 10 Jul 2008 14:44:00 -0700, reddy <(E-Mail Removed)>
wrote:

>Thank you. That worked!
>
>"Gord Dibben" wrote:
>
>> 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
>>
>> On Wed, 25 Jun 2008 09:41:00 -0700, Query Analyzer User
>> <(E-Mail Removed)> wrote:
>>
>> >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
>>
>>