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!

why is there a "^" in the cell?
 

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" wrote in message
...
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!

why is there a "^" in the cell?
 

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" wrote in message
...
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!

why is there a "^" in the cell?
 

Try
EditReplace....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" wrote in message
...
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!

why is there a "^" in the cell?
 

Good idea. Thanks.

"ufo_pilot" wrote:

Try
EditReplace....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" wrote in message
...
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!

why is there a "^" in the cell?
 

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

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


"LBoogie" wrote in message
...
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" wrote in message
...
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!