Persistent Text to Columns...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RickGreg - 10 Jul 2007 20:11 GMT

I've been using the Text to Columns command recently and it is driving me
crazy.

Each time I use it, every subsequent time I paste something in Excel, it
parses the contents of my paste to columns.

This behavior persists even when I open a new workbook.

The only solution I've found is to quit/restart Excel, after which
everything is back to normal.

Any ideas?

[Excel 11.3.3 (061213) OSX 10.4.10]

Thanks in advance!

Reply to this Message

CyberTaz - 10 Jul 2007 21:46 GMT

I'm not certain, but since the T-T feature doesn't involve the clipboard I
think you may have some degree of OS interaction going haywire... especially
since copying/cutting other material replaces whatever is currently on the
clipboard. Based on your version info, the first thing I'd suggest is that
you download & [re]apply the current Office 11.3.5 updater, run Disk
Utility - Repair Disk Permissions & see if that makes a difference.

If no improvement post back with a bit more detailed description of how
you're going about things.

Signature

HTH |:>)
Bob Jones
[MVP] Office:Mac

> I've been using the Text to Columns command recently and it is driving me
> crazy.
[quoted text clipped - 12 lines]
>
> Thanks in advance!

Reply to this Message

RickGreg - 11 Jul 2007 01:42 GMT

> I'm not certain, but since the T-T feature doesn't involve the clipboard I
> think you may have some degree of OS interaction going haywire... especially
[quoted text clipped - 5 lines]
> If no improvement post back with a bit more detailed description of how
> you're going about things.

Thanks. That seems to have worked. FWIW, I recall the same thing happening
in years past with vastly different versions of OS and Office. Odd.

Reply to this Message

CyberTaz - 11 Jul 2007 10:59 GMT

On 7/10/07 8:42 PM, in article
C2B99FAD.196CA%rgregory@NOSPAMPLEASEfoxandcompany.com, "RickGreg"
<rgregory@NOSPAMPLEASEfoxandcompany.com> wrote:

>> I'm not certain, but since the T-T feature doesn't involve the clipboard I
>> think you may have some degree of OS interaction going haywire... especially
[quoted text clipped - 8 lines]
> Thanks. That seems to have worked. FWIW, I recall the same thing happening
> in years past with vastly different versions of OS and Office. Odd.

Odd? Not really... Each update to the OS involves *changes* so the apps get
updates accordingly. "Updates" are actually *patches* that fix/modify
aspects of the software. If the OS updates get applied & the app updates
don't (or vice-versa) the 2 quite likely no longer "sync" the way they need
to. In your case Office was two steps behind OS X - quite frankly, I'm glad
you didn't have more serious problems:)

Thanks for confirming the fix!

Regards |:>)
Bob Jones
[MVP] Office:Mac

Reply to this Message

Mac Forum / Applications / Excel / July 2007

Persistent Text to Columns...