How to replace existing text in different format in certain column with some standard text

[Shaopingfu]

I want to remove exiting text in column "Text", and input the formatted text with below conditions-
1) for line items having Offset vendor code started with "E", the test should be - "Pay T&E" + name in column- Offset vendor description + Year (yyyy) Month (mm) per column - Posting Date
2) for line items having Offset vendor code started with non- "E", the test should be "Pay” + code in column- Offset vendor

[Zok]

Hello

One way of doing this

[binuacs]

@Shaopingfu Another approach with STartsWith function()

IIF(StartsWith([Offset vendor], 'E'), "Pay T&E " + [Offset vendor description] + DateTimeFormat([Posting Date],'%Y%m') ,'Pay ' +[Offset vendor])