Excel Help and Problems

[gozalim]

not following

if we're having comparisons both before and after the text, how do we ensure that it always chooses the right 'section' of the search to replace?

[etech0]

if we're having comparisons both before and after the text, how do we ensure that it always chooses the right 'section' of the search to replace?

You'll add in the first OR group with $1, and the second one with $2. Assuming that I'm understanding your question correctly.

[gozalim]

You'll add in the first OR group with $1, and the second one with $2. Assuming that I'm understanding your question correctly.

If you're doing them both separately, you run into my original question

[etech0]

If you're doing them both separately, you run into my original question

Each OR group is surrounded by parenthesis, you do them both at once. You'll reference them in your replacement string with $1 and $2.

Can you post the formula you're working with now so that we're on the same page?

[gozalim]

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 ירמיה?

[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