Help with a formula

Question

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 1Column 2IND IIIIIND IIIIIIIND IVIVIND JRJRIND JRSR

AndrewSu · Answer

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

Thanks!

Idyllic_Data_Geek · Answer

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