Multi Layered IF then Formula Using Left and Right

Mike_at_CG

Hi All

Hoping to get some help from the community on the below formula.

I am attempting to see if the left 2 digits in an account are equal to 43,45 or 46 if so then replace 43,45 and 46 with 44 + the right 6 digits of the same account.  If the left two digits are equal to 44 or 11 then just keep the same account.

In Excel it would be something like this =if left(Account),2 = "43" Then Concatenate "44",Right(Account),if left(Account),2 = "45" Then Concatenate "44",Right(Account), if left(Account),2 = "46" Then Concatenate "44",Right(Account), Account

Thank you for your time

DataNath

Hey @Mike_at_CG, how does this look?

Input:

Output:

This relies on your [Account] field being a string - if it's not, just throw on a Select tool beforehand and make it a string. It'll be more intuitive than filling your expression with multiple type conversion functions.

Replace certain first 2 chars with 44.yxmd