ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   delete and replace (https://www.excelbanter.com/excel-programming/415758-delete-replace.html)

John[_19_]

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

NoodNutt

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.




Gord Dibben

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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com