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

data.png

Data Investigation

Accepted answers

flying008

Hi, @Ronal_bal

FYI.

录制_2023_07_18_08_33_38_217.gif

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

All comments

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?

ReplaceWordyxmd.yxmd

flying008

Hi, @Ronal_bal

FYI.

录制_2023_07_18_08_33_38_217.gif

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

For Ronal_bal.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335