How do I get Rid of the Circumflex Accent (Caret)

  • Thread starter Thread starter tb
  • Start date Start date
T

tb

I am using Excel 2007 on a Windows 7 platform.

I have a spreadsheet with a bunch of blank cells but when I select any
of these cells I can see the caret (^) sign in them.

How do I get rid of them (i.e. blank out the fields) in a fell swoop?

I tried to use the Replace option (Find What: ^; Replace With: <blank>)
but that does not work...
 
Hi,

Am Thu, 21 Aug 2014 15:49:30 +0000 (UTC) schrieb tb:
I have a spreadsheet with a bunch of blank cells but when I select any
of these cells I can see the caret (^) sign in them.
Click to expand...

that is a prefix for right aligned text.
Format the cells General.


Regards
Claus B.
 
See Claus's answer but I will add to it.

You must uncheck the Transition Options and I also believe your cells
have a non-visible space in them otherwise the caret would not be
visible.

Gord
 
Back
Top