Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 87
Default delete and replace

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 221
Default delete and replace

G'day John

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

HTH
Mark.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default delete and replace

Have you tried EditReplace?

If so, what problems did you encounter?


Gord Dibben MS Excel MVP

On Fri, 15 Aug 2008 22:27:05 -0500, John 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How to find and replace with blanks or actually delete row Patmarie985 Excel Worksheet Functions 1 November 10th 08 06:31 PM
How to Delete a Range in Closed Workbook (to Replace Delete Query) [email protected] Excel Discussion (Misc queries) 1 March 8th 06 10:10 AM
Substitute ,replace and delete in a cell. Doug Excel Worksheet Functions 2 November 9th 05 03:50 PM
Macro to delete and replace a text box Dave Excel Programming 6 February 24th 05 10:59 PM
Macro to delete and replace a text box Dave Excel Discussion (Misc queries) 0 February 24th 05 05:17 PM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"