I got Dups....

[hi2019]

Hi,

I am trying to only show the roman numeral only but now its showing both 4 IV at the end of Pay Name- I think I have to correct this formula or add another formula to remove this -please help

elseif Contains([Pay name], " 2" ) THEN [Pay name]
+ 'II'

elseif Contains([Pay name], " 3" ) THEN [Pay name]
+ 'III'
elseif Contains([Pay name], " 4" ) THEN[Pay name] + 'IV' ELSE [Pay name]

is this part of a larger formula -  am sure it is from this part though

thanks!!!!!

[Qiu]

@hi2019 
Can you give some input and desired output?
I can not quite get your question, sorry.

[flying008]

Hi, @hi2019 

Try this formula:

Left([Pay Name], Length([Pay Name]) -1) + Switch(Right([Pay Name], 1), Right([Pay Name], 1), '1', 'I' , '2', 'II', '3', 'II', '3', 'III', '4', 'IV', '5', 'V', '6', 'VI', '7', 'VII', '8', 'VIII', '9', 'IX')

[hi2019]

It didnt work but it could be because of how I explained 

how can I trim it only for those roman numerals to show only 

[Deano478]

@hi2019 What does the data look like we cant just be guessing?

[Carlithian]

It sounds like you are wanting to swap the arabic number with the roman numeral

E.g 

Litten 4 would become Litten IV

I would recommend using a find replace and a text input