REPLACE("Text"; Position; Length; "NewText") Text refers to text of which a part will be replaced. Position refers to the position within the text where the replacement will begin. Length is the number of characters in Text to be replaced. NewText refers to the text which replaces Text. Enhancement requested: *** Text and NewText can be regular expressions. *** This enhancement is compatible with existing REPLACE.
From what I can tell Microsoft does not do this with Excel. This could potentially cause some serious interoperability issues. That being said, I'll mark as NEW because it's a valid request with caveat on the below. Enhancement requests are handled entirely by volunteers. The volunteer needs to find the enhancement both interesting and within their skillset. Furthermore, they'd have to weigh the benefit (which seems quite small, likely of our millions of users only a handful would ever use this) against the cost (interoperability and time). This particular enhancement seems to be quite difficult which means only a few developers would have the potential skills. Furthermore, the cost could be quite high. To be realistic, I don't think this will ever be implemented but it'll be in the database just in case someone wants to try to tackle it.
I am asking only for what is available already in the Find and Replace dialog. I had hoped that code reuse would be possible in enabling this in a Calc function.
(In reply to David Lynch from comment #2) > I am asking only for what is available already in the Find and Replace > dialog. I had hoped that code reuse would be possible in enabling this in a > Calc function. Unlikely. The code is very different.