To replace multiple strings in an excel cell

Help
, ,
1

I want to replace multiple strings. like i have some data in excel cell:
{Client_Id} (trans_Id} {User_Id} and i want to replace {Client_Id} with 1234, {trans_Id} with x23B and {User_Id} with @121bcd. Please suggest to perform this.

Thanks

1 Like
2

can you please try this,

3

I saw that link there its given for different rows, i need to replace different values in same cell

4

Try this out,

image
image865×633 17.3 KB

((variable1.replace(“{Client_Id}”,“1234”)).replace(“(trans_Id}”,“x23B”)).replace(“{User_Id}”,“@121bcd”)

1 Like
5

Thanks Buddy! It worked :slight_smile: