why is there a "^" in the cell?

Copied a worksheet, now both original and copy have "^" in the cells, causing
formatting to be off. Words won't center horizontally or vertically and can't
retype cell contents w/out it putting the "^" back in the cell. HELP!

Try Tools / Options / Transition / Untick 'Transition navigation keys' if it
is ticked.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"LBoogie" <LBoogie@discussions.microsoft.com> wrote in message
news:B5C39D34-1D80-400F-A8C1-B60D3502F83C@microsoft.com...
> Copied a worksheet, now both original and copy have "^" in the cells,
> causing
> formatting to be off. Words won't center horizontally or vertically and
> can't
> retype cell contents w/out it putting the "^" back in the cell. HELP!
>

Unfortunately, that didn't work. However, I did "untick" the navigation keys
before I copied the worksheet. Could this be the reason the "^" is in the
cells? How do I get rid of it? Thanks for your response and input!

"Ken Wright" wrote:

> Try Tools / Options / Transition / Untick 'Transition navigation keys' if it
> is ticked.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------Â*------------------------------Â*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------Â*------------------------------Â*----------------
>
>
>
> "LBoogie" <LBoogie@discussions.microsoft.com> wrote in message
> news:B5C39D34-1D80-400F-A8C1-B60D3502F83C@microsoft.com...
> > Copied a worksheet, now both original and copy have "^" in the cells,
> > causing
> > formatting to be off. Words won't center horizontally or vertically and
> > can't
> > retype cell contents w/out it putting the "^" back in the cell. HELP!
> >
>
>
>

Try
Edit>Replace....Find ^ ....Replace (leave blank)


"LBoogie" wrote:

> Unfortunately, that didn't work. However, I did "untick" the navigation keys
> before I copied the worksheet. Could this be the reason the "^" is in the
> cells? How do I get rid of it? Thanks for your response and input!
>
> "Ken Wright" wrote:
>
> > Try Tools / Options / Transition / Untick 'Transition navigation keys' if it
> > is ticked.
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
> > ------------------------------Â*------------------------------Â*----------------
> > It's easier to beg forgiveness than ask permission :-)
> > ------------------------------Â*------------------------------Â*----------------
> >
> >
> >
> > "LBoogie" <LBoogie@discussions.microsoft.com> wrote in message
> > news:B5C39D34-1D80-400F-A8C1-B60D3502F83C@microsoft.com...
> > > Copied a worksheet, now both original and copy have "^" in the cells,
> > > causing
> > > formatting to be off. Words won't center horizontally or vertically and
> > > can't
> > > retype cell contents w/out it putting the "^" back in the cell. HELP!
> > >
> >
> >
> >

Good idea. Thanks.

"ufo_pilot" wrote:

> Try
> Edit>Replace....Find ^ ....Replace (leave blank)
>
>
> "LBoogie" wrote:
>
> > Unfortunately, that didn't work. However, I did "untick" the navigation keys
> > before I copied the worksheet. Could this be the reason the "^" is in the
> > cells? How do I get rid of it? Thanks for your response and input!
> >
> > "Ken Wright" wrote:
> >
> > > Try Tools / Options / Transition / Untick 'Transition navigation keys' if it
> > > is ticked.
> > >
> > > --
> > > Regards
> > > Ken....................... Microsoft MVP - Excel
> > > Sys Spec - Win XP Pro / XL 97/00/02/03
> > >
> > > ------------------------------Â*------------------------------Â*----------------
> > > It's easier to beg forgiveness than ask permission :-)
> > > ------------------------------Â*------------------------------Â*----------------
> > >
> > >
> > >
> > > "LBoogie" <LBoogie@discussions.microsoft.com> wrote in message
> > > news:B5C39D34-1D80-400F-A8C1-B60D3502F83C@microsoft.com...
> > > > Copied a worksheet, now both original and copy have "^" in the cells,
> > > > causing
> > > > formatting to be off. Words won't center horizontally or vertically and
> > > > can't
> > > > retype cell contents w/out it putting the "^" back in the cell. HELP!
> > > >
> > >
> > >
> > >

Yep, and you've had the answer to getting rid of it :-)

Regards
Ken.................


"LBoogie" <LBoogie@discussions.microsoft.com> wrote in message
news:24CC80F7-4EC4-4745-9BD6-CB8F80BC3260@microsoft.com...
> Unfortunately, that didn't work. However, I did "untick" the navigation
> keys
> before I copied the worksheet. Could this be the reason the "^" is in the
> cells? How do I get rid of it? Thanks for your response and input!
>
> "Ken Wright" wrote:
>
>> Try Tools / Options / Transition / Untick 'Transition navigation keys' if
>> it
>> is ticked.
>>
>> --
>> Regards
>> Ken....................... Microsoft MVP - Excel
>> Sys Spec - Win XP Pro / XL 97/00/02/03
>>
>> ------------------------------*------------------------------*----------------
>> It's easier to beg forgiveness than ask permission :-)
>> ------------------------------*------------------------------*----------------
>>
>>
>>
>> "LBoogie" <LBoogie@discussions.microsoft.com> wrote in message
>> news:B5C39D34-1D80-400F-A8C1-B60D3502F83C@microsoft.com...
>> > Copied a worksheet, now both original and copy have "^" in the cells,
>> > causing
>> > formatting to be off. Words won't center horizontally or vertically and
>> > can't
>> > retype cell contents w/out it putting the "^" back in the cell. HELP!
>> >
>>
>>
>>