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

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...
 
C

Claus Busch

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

the computer keyboard broken (software side I think ) 8
How do I insert the caret mark over a letter? 4
Windows 10 How to get rid of lines on documents 2
get rid of focus 3
How to get rid of #n/a 1
With a Function, how can I get rid of formating codes like <div> ? 30
get rid of a paintbrush in an excel box 1
How do I get rid of #DIV/0! 4

Top