http://fspro.net/my-lockbox/
Welcome to the Fortismere School ICT Blog. Here you can find the most up to date information on resources, community classes and events. Also, check out the tab on student work.
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
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
Subscribe to:
Posts (Atom)