Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

or ' before text in a cell that will not go away. HELP!!!!!!!

Posted by Josh on January 23, 2002 10:52 AM

I have a spreadsheet with text fields where the value of every cell is preceded with either an ' or a ^. I can't get this to go away. For example the cell will have ^Name but show up as Name. when i go in to the cell and remove the ^, it just shows up again. suggestions?????

Check out our Excel Resources

Re: ^ or ' before text in a cell that will not go away. HELP!!!!!!!

Posted by Joe Was on January 23, 2002 11:09 AM

I have seen this in sheets converted from Lotus, but in Excel it should not happen. Try and check to see what the cell is formatted as. General or Text should be OK.

You can try to replace the ^ with "" where "" is nothing-Blank form the menue toolbar(Edit-Replace) find then replace. JSW

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.