I am very novice excel user (real estate appraiser) working to match public records from a tax records export to properties in our database which has been exported to another spreadsheet. We have tool to do the match and get schema right, using APN (Assessor Parcel No) to match the records. I need help with formula involves removing dashes and spaces in the APN so they will match the the way the APN is reported in our data base. The somewhat irregular nature of the APN causes problem The EE provided formula =SUBSTITUTE(A2."-"."") only partly worked.
Here is specific question/screenshot
How do I match column A match column b. In the example below, it does not show that some APNs will have a single letter at the tail end(no space).