Separating Last Two Characters Into Different Column

[mf16627]

What is the best way to separate the last two characters into a different column? Example below:

Combined	Item	Item Type
Dual packPP	Dual pack	PP
Snow cone cups, 50 pcsSC	Snow cone cups, 50 pcs	SC
Hot Dog Buns, 24 pcsHD	Hot Dog Buns, 24 pcs	HD
Popcorn Salt, 80 oz, garlic butterPP	Popcorn Salt, 80 oz, garlic butter	PP

[Prometheus]

@mf16627 I used a Formula tool to create Item Type using this expression: Right([Combined ], 2). Then I created Item by replacing the values I removed from Combined with nothing: Replace([Combined ], [Item Type], '').

 

[ed_hayter]

Opted for a right([field], 2) string function to get the last two characters then a left([field], findstring([field], [target]). To then make a column with everything preceeding the last two characters.

[Deano478]

hey @mf16627 you can use the text to columns tool with this delimiter  and split to 3 columns:

(.*?)([A-Z]+)$