Excel Help and Problems

[etech0]

If I run

Code: [Select]

((\A| |-|^|ק|ר|ש|ת))טו((\A| |-|^|,))
in a single search than I run into problems with

Code: [Select]

$1יה

and If I do them separately, 1st

Code: [Select]

((\A| |-|^|ק|ר|ש|ת))טוthen

Code: [Select]

טו((\A| |-|^|,))
what stops the 1st search from catching יהושע? or the last on from catching ירמיה?

I think you want to close the first set of parens before the טו.

[gozalim]

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

[etech0]

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?

[gozalim]

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

[etech0]

i'm using gdocs with regex selected.
tried with each of those examples

What do you mean by "regex selected"?

[gozalim]

What do you mean by "regex selected"?

it's a checkbox on the expanded search box

[etech0]

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.

[gozalim]

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

[etech0]

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!

[gozalim]

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?

[etech0]

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

[gozalim]

I don't think so, but you can nest one formula inside the other

but that would give me the whole cell doubled

[etech0]

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.

[gozalim]

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.

Code: [Select]

=xREPLACE(xREPLACE("((\A| |-|^))טו",A1,"יה")"((\A| |-|^))טז",A1,"יו")giving me an error msg

[etech0]

Code: [Select]

=xREPLACE(xREPLACE("((\A| |-|^))טו",A1,"יה")"((\A| |-|^))טז",A1,"יו")giving me an error msg

It's hard to debug because I don't have the plugin installed, but at first glance it looks like you're missing the quotation marks around the [@[כרך (א)]] parts