MID and FIND in Excel

Cell A1 107 Smith Street

If the above is in one cell A1 in a spreadsheet what would the following formulae do?

Cell B1 =MID(A1, 1, FIND(" ",A1)-1)*1
Cell C1 =MID(A1, 1, FIND(" ",A1)-1)+1,100

No comments:

Post a Comment