Extract Values After first 2 Chars for certain values

[Masond3]

Hi Team, 

Hope your well. 

I need some help,

For a particular sub set of countries (United States, Australia, Canada)  i would like to produce a new column which extracts the State ISO

Country : Country ISO 
Country2 : Country Name 
State/Province : CountryISO + State ISO

Example Data 

Country	Country2	State/Province
AU	Australia	AUNSW
AU	Australia	AUVIC
AU	Australia	AUWA
CA	Canada	CAON
US	United States	USOH
US	United States	USOR

Expected Outcome 

Country	Country2	State/Province	State/Province ISO
AU	Australia	AUNSW	NSW
AU	Australia	AUVIC	VIC
AU	Australia	AUWA	WA
CA	Canada	CAON	ON
US	United States	USOH	OH
US	United States	USOR	OR

Looking forward to your help 

Regards
Masond3

[Ben_H · Accepted solution]

Hi @Masond3 

There are various ways of doing this -

If you are always going to have that country column you could try this - replace([State/Province],[Country],"")

Or if not this would work - Substring([State/Province],2,3)

Regards,

Ben

[Masond3]

Hey 

Thank you so much for your input. its simple but effective 🙂 

Have a great Day