Posted to microsoft.public.excel.newusers

Joanne

external usenet poster

Posts: 121

Apostrophes in formula bar

I have been given a worksheet with hunderds of rows and a couple dozen
columns.
All the data entry has been preceeded by an apostrophe in the formula
input bar. I tried find/replace, but it does not see the apostrophes.
Could someone please tell me how to do a global erasure of these
apostrophes throughout the entire worksheet?
Thanks so much for you help
Joanne

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
apostrophes	teepee[_3_]	Excel Discussion (Misc queries)	21	February 14th 08 01:05 AM
Apostrophes in Cell	Megadrone	Excel Worksheet Functions	4	February 22nd 07 01:51 PM
Apostrophes and Sorting	[email protected]	Excel Discussion (Misc queries)	3	October 23rd 06 02:01 PM
Apostrophes instead of equals in Excel	ARH	Excel Worksheet Functions	3	August 20th 05 12:18 AM
how do i get rid of hidden apostrophes in cells?	brokenmonkey	Excel Worksheet Functions	4	November 17th 04 01:53 PM

All times are GMT +1. The time now is 02:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us