For example, after splitting a string into multiple parts, you can use INDEX to retrieve the second or third segment directly. How to Extract Any Part of Cell Automatically in Excel ...