Hello,
I cannot get my formulas to work, and everything i have found only seems to work for numbers which does me no good.
I have a field with cities and states in it and want to split it to 2 columns one with city one with state. but the problem is some have a period between then, some have a comma and some have nothing between the 2. some Cities have a period in them already (ie. St. Louis) and some are multiple words (IE Cuyahoga Falls) the only common thing is that the last 2 letters are always the state. so i tried trim right/left to return the value without the last 2 and the value that is only the last 2... but have had no success. as soon as i try to put in the length of how many characters to return the formula stops working. like it doesnt want me to put a number in the length part.
