parse v. regex v. formula?

[DDeCree]

How can I take the existing cell below and make it like the desired cell below?

Existing Cell:

AnyBank N.A., Paris branch, AnyBank Bank N.A., Singapore branch, AnyBank (Suisse) S.A., AnyBank Luxembourg S.A., Head Office

Desired Cell:

AnyBank N.A., Paris branch; AnyBank N.A., Singapore branch; AnyBank (Suisse) S.A.; AnyBank Luxembourg S.A., Head Office

[messi007]

@DDeCree,

Please see below :

Hope this helps,

Attached the workflow,

[OllieClarke · Accepted solution]

Hey @DDeCree, you can get the text to align using the following formula:

Replace(Replace([Field1],' Bank',''),', AnyBank','; AnyBank')

Which will remove the instance of Bank after AnyBank and also replace all commas with a semi-colon if they immediately precede AnyBank.

Hope that helps,

Ollie

[DDeCree]

thank you for the assistance.

[DDeCree]

thank you.