delete and replace

's Computer Specifications

Is there a way to delete all occurrences of a charcater in a range?

Also... is there a way to replace all occurrences of a character in a range?

thanks

John

's Computer Specifications

G'day John

Try this add-in named FlexFind from Jan Karel Pieterse.
http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.asp

HTH
Mark.

's Computer Specifications

Have you tried Edit>Replace?

If so, what problems did you encounter?

Gord Dibben MS Excel MVP

On Fri, 15 Aug 2008 22:27:05 -0500, John <(E-Mail Removed)> wrote:

>Is there a way to delete all occurrences of a charcater in a range?
>
>Also... is there a way to replace all occurrences of a character in a range?
>
>thanks
>
>John

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
replace and delete	dallball	Microsoft Word Document Management	1	25th Feb 2009 06:36 AM
How to Delete a Range in Closed Workbook (to Replace Delete Query)	resant_v@yahoo.com	Microsoft Excel Misc	1	8th Mar 2006 10:10 AM
Delete / replace a dll that is in use	Patrick B	Microsoft C# .NET	3	5th Feb 2005 08:58 AM
Delete Worksheet and replace/delete links	Shaz	Microsoft Excel Discussion	3	8th May 2004 12:59 PM
Replace methode, Replace Function, Stringbuilder replace, Regex Replace, Split	Cor	Microsoft VB .NET	4	1st Mar 2004 02:50 PM