Substituting symbol in a specific area within a string

[jj4jj]

Good afternoon from Europe,

I have to substitute the "_" symbol with an another symbol "+" in a specific area--------------all "_" lying between "/" and "CDE" in a text string.

example:

What I have:

QQQ/AAA_BBB_CDE_FGH_IJK_LMN

What i need:

QQQ/AAA+BBB_CDE_FGH_IJK_LMN

Is it possible to perform without a macro only with a function?

Many thanks for every reply!

[shg]

From your description, why isn't the second underscore replaced?

Is it always just the first underscore? If not, please provide more examples.

[jj4jj]

I am sorry for unprecise explanation and examle...here´s a new one:

example:

What I have:

QQQ/AAA_BBB_CCC_CDE_FGH_IJK_LMN

What i need:

QQQ/AAA+BBB+CCC_CDE_FGH_IJK_LMN

[shg]

Row\Col	A	B	C
1	QQQ/AAA_BBB_CCC_CDE_FGH_IJK_LMN	QQQ/AAA+BBB+CCC_CDE_FGH_IJK_LMN	B1: =SUBSTITUTE(LEFT(A1, FIND("_CDE", A1) - 1), "_", "+") & MID(A1, FIND("_CDE", A1), LEN(A1))
2	QQQ/AAA_BBB_CDE_FGH_IJK_LMN	QQQ/AAA+BBB_CDE_FGH_IJK_LMN

[jj4jj]

thanks for reply and solution..in this example it´s working fine: but to be even more specific: the area of substitution lays between "/" and "CDE", so this function doesn´t work for following example:

What I have:

OOO_PPP_QQQ/AAA_BBB_CCC_CDE_FGH_IJK_LMN

What i need:

OOO_PPP_QQQ/AAA+BBB+CCC_CDE_FGH_IJK_LMN

[shg]

That's why I asked for a representative set of examples.

[shg]

=LEFT(A1, SEARCH("/", A1))
& SUBSTITUTE(LEFT(MID(A1, SEARCH("/", A1) + 1, LEN(A1)), SEARCH("_cde", MID(A1, SEARCH("/", A1) + 1, LEN(A1))) - 1), "_", "+")
& MID(A1, SEARCH("_cde", A1), LEN(A1))

[jj4jj]

working great, many thanks...and i am one more time sorry for my bad explanation...

[shg]

You're welcome.

[AlKey]

Deleted post