Need to replace the word

[Ronal_bal]

I need to replace the 'AA' before the before word. 

Attached the example with Input & Output

Any help would be appreciated

[JimmyV]

Hi Ronal_bal,

I was able to accomplish this utilizing the Multi-Row Formula and the Tile tools. I've attached the workflow to this reply. Let me know if you have any questions or if it worked for you?

[flying008 · Accepted solution]

Hi, @Ronal_bal 

FYI.

Input		Input	Output
ABCD		ABCD
AA		AA	ABCD
AA		AA	ABCD
AA		AA	ABCD
EFGH		EFGH
AA		AA	EFGH
AA		AA	EFGH
AA		AA	EFGH
AA		AA	EFGH

[caltang]

Hi @Ronal_bal - this is is one more way, it's a bit more lengthy but it takes you through step by step so that you can understand the process better.

I highly recommend for you to try this and to build something of your own as well so that you can learn. 

Hope this helps!

-Cal