All Questions
Tagged with worksheet-function address
1
question
0
votes
0
answers
9
views
Formula Name Error converting address list to address block list
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)) ...