On this dialog box, you’ll see an alternative that lets you specify whether the data in your chosen cells are delimited. Should you’re not familiar with the term ‘delimited’, it is the character that specifies how the data inside the cells are separated from Just about every other, one example https://www.customguide.com/excel/hlookup