For this example, you don’t need to change any options, so click Next. The default delimiter is the Tab character (but this feature remembers your last setting, so it might be different). Check Semicolon and uncheck any others (if necessary). When you do, Excel previews the change. Pay attention to this display because it’ll alert you to problems. In this case, Excel doesn’t update the last record. In addition, a lot depends on your text qualifier. If set to none, Excel retains the quote characters.
Fortunately, this feature’s flexible enough to handle more than one delimiter. Check the Other option, enter a colon, and watch what happens in the preview pane. Excel properly divides the first and last names in all of the records and the quotation marks are gone! Click Finish to see the foreign data divided and cleaned of the text-qualifying characters (the quotation characters).