Help with a formula

[Idyllic_Data_Geek]

I'm trying to write a formula for the below requirement

If column 1 contains II then Column 2 = II

elseif column 1 contains III then column 2 = III

elseif column 1 contains IV then column 2 = IV

elseif column 1 contains JR then Column2 = JR

elseif column 1 contains SR then column 2 = SR

else null()

Column 1	Column 2
IND II	II
IND III	III
IND IV	IV
IND JR	JR
IND JR	SR

[Idyllic_Data_Geek]

I got it figured out with the Regex match calc. Please ignore my ask

[AndrewSu]

Hi @Idyllic_Data_Geek ,  do you  mind sharing your solution here so that other's in the community can learn?

Thanks!