So I wasn't actually aware of this behavior with the Split Function (although not used it that much), but it does make sense. If it did, as you thought it would, you wouldn't be able to write a Split 3...as the rest of the string, following the Split 1 would have been captured in Split 2...it would be confusing if the number of Split formulas affected the results of others. Also if you only wanted the SPC you wouldn't be able to do it with the Split function. In essence it's using the '-' separator (in your case) to tokenise out the parts and then uses the index to allow you to access which part you want.