Posted to microsoft.public.excel.misc

James T

Posts: n/a

FIND and REPLACE ' apostrophe

I have a spreadsheet that has a column of functions that start with an
apostrope '

I need to remove the ' from the start of the function.

Tried using FIND/REPLACE but it does not like it.

Any ideas?

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
Macro: Find and replace	Bertie	Excel Discussion (Misc queries)	1	May 29th 06 02:01 PM
How do I find and replace the "	mawmawball	Excel Discussion (Misc queries)	8	December 22nd 05 01:19 AM
Find and Replace	blakrapter	Excel Worksheet Functions	3	December 15th 05 12:25 AM
Find and replace of word causes change of font formatting	jwa90010	New Users to Excel	4	July 22nd 05 08:10 PM
VB Find and Replace	Bony_Pony	Excel Worksheet Functions	10	December 6th 04 05:45 PM

All times are GMT +1. The time now is 05:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us