Replace Text from 2nd Column in between Delimiters in First

[rjb1]

Hi,
Could someone please help with this problem:

I have two columns of text.
A B
"ABCD" "CDEF" REPTEXT1
"GHIJ" "KLMN" REPTEXT2

I need a macro to take the replacement text and put it in between
the delimiter of choice. In this case, the second set of quotes.

Result:
"ABCD""REPTEXT1"
"GHIJ""REPTEXT2"

Thanks!

 

[BrianB]

If the text is consistent :_
=CONCATENATE(LEFT(A1,6),"""",B1,"""")

 

[rjb1]

Thanks Brian but the text is not consistent.

 

[PaddyD]

"Thanks Brian but the text is not consistent."

You need to be more explicit about your data:

- will the delimiter always be a "
- will you always be replacing between the third and forth instances of the delimiters (or.for exampole, is it between the last pair?)
- is the text to replace always 4 characters long?

 

[PA HS Teacher]

Not the most efficient formula, but I believe this array entered formula will do the trick: (I'm assuming the text in Cell A1 is no more than 100 characters long.)

=REPLACE(A1,SMALL((MID(A1,ROW(1:100),1)<>"""")*9.9E+307+ROW(1:100),3)+1,
SMALL((MID(A1,ROW(1:100),1)<>"""")*9.9E+307+ROW(1:100),4)-
SMALL((MID(A1,ROW(1:100),1)<>"""")*9.9E+307+ROW(1:100),3)-1,"ReplaceText1")

Confirmed with Control + Shift + Enter