If I runCode: [Select]((\A| |-|^|ק|ר|ש|ת))טו((\A| |-|^|,))in a single search than I run into problems withCode: [Select]$1יהand If I do them separately, 1stCode: [Select]((\A| |-|^|ק|ר|ש|ת))טוthenCode: [Select]טו((\A| |-|^|,))what stops the 1st search from catching יהושע? or the last on from catching ירמיה?
((\A| |-|^|ק|ר|ש|ת))טו((\A| |-|^|,))
$1יה
((\A| |-|^|ק|ר|ש|ת))טו
טו((\A| |-|^|,))
I think you want to close the first set of parens before the טו.
I did. it's not showing up correctly here due to language switch.copy and paste it and you'll see
Are you using regexreplace? Can you post your full formula so I can copy it?
i'm using gdocs with regex selected.tried with each of those examples
What do you mean by "regex selected"?
it's a checkbox on the expanded search box
Oh, I didn't even know that I was referring to the REGEXREPLACE formula where you tell it a cell, the regex to look for in there, and the string to replace it with.
would this serve the same purpose as Gdocs?http://blog.malcolmp.com/2010/regular-expressions-excel-add-in
I haven't tried it, but it looks like it might. Let me know if it works!
looks like it's doing what it was intended.should I be able to nest both replacements (טו\יה and טז\יו) into a single xREPLACE?
I don't think so, but you can nest one formula inside the other
but that would give me the whole cell doubled
Not if you put one inside the other. IE: build one xReplace formula, and use it's entirety inside as the "text" inside the other.
=xREPLACE(xREPLACE("((\A| |-|^))טו",A1,"יה")"((\A| |-|^))טז",A1,"יו")
Code: [Select]=xREPLACE(xREPLACE("((\A| |-|^))טו",A1,"יה")"((\A| |-|^))טז",A1,"יו")giving me an error msg