A template to separate data in mixed format in an Excel column no longer functions.
23 Echo Lane
Could be separated by:
=LEFT(A2,FIND(" ",A2)-1) pasted into a new adjacent blank column
pasted into a new adjacent blank column on the opposite side of the target column
23 in one column and Echo Lane in another column with the original column in between the two new columns
Now an error "#NAME?" is returned instead of the parsing of the data.