Scenario — Tables are listed as such: Address Address 2 (for Suite number, Apartment, etc.) City ST Zip I’m making a formula in a table. If I make the formula {Address} & “,” & {Address 2} & & " | {City} & “,” & {ST} & " " Result: 123 Any St., Su...

I could not figure out why when doing an alphabetical sort, some records were coming in “at the bottom.” For example I’d have A to Z for records 1 to 100 followed by a second A to Z of records 101 to 200. I could see no extra spaces, or anything to i...