I have used the Excel functions LEFT ... all our customer information is contained in a single cell, with each piece of data separated by either a comma and a space or a semicolon and a space. We can ...