AnsweredAssumed Answered

separating state  from citystatezip formula does not work   ie  Middle (CityStateZip,Position (CityStateZip,", ",1)   2, 2)

Question asked by mmburke33 on May 19, 2017
Latest reply on May 20, 2017 by philmodjunk

does anyone have an answer if city is one or two words?

formula given in knowledge base does not function at all

Middle (CityStateZip,Position (CityStateZip,", ",1)   2, 2)  

Outcomes