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
Solved! Go to 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
thank you for the assistance.
thank you.