I am trying to compare two text fields [Field1] and [Field2]. If fields do not match, I want to say ?Mismatch.?
The example below is a match; I need to create a formula that will always take lower case ?g? and change it to ?G? then see if [Field1] and [Field2] match.
Data in [Field1] is 12345678g