0
6240 Grand Blvd; Grace Church to 6200 Block Grand Blvd.; Grace Church

To convert addresses to block listed addresses I am trying to use this four step formula:

=LEFT(A2,(FIND(" ",A2,1)-1))  
=MID(A2,FIND(" ",A2),200)
=CONCAT(FLOOR(B2,100)," BLOCK",C2)
=CONCAT(FLOOR(LEFT(A2,(FIND(" ",A2,1)-1)),100)," BLOCK",MID(A2,FIND(" ",A2),200))

Step three and four, I am receiving #NAME? error.

New contributor
Suzanna Elizabeth Enslen is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

0

You must log in to answer this question.

Browse other questions tagged .