Skip to content

LAPD

Jump to bottom
albertkun edited this page Mar 6, 2017 · 1 revision

In order to get one field for the street addresses we need to concatenate. We used an Excel formula to do the concatenation as follows:

  1. We added a new field in column Y called "StreetAddress"

  2. We input the following formula:

    =CONCATENATE(Z2,IF(AA2<>""," "&AA2,"")," "&AB2)

  3. Then we applied this change to all of the rows.

  4. We then copy and pasted the column as "value only" so that the values would be preserved, rather than the formulas.

Clone this wiki locally