Q. I have several product numbers that each appear in a single cell in Excel. Each product number contains the product line (the first three digits), the product color (the middle four digits), and ...

Kelly L. Williams, CPA, Ph.D., explains how to use XLOOKUP, a new function for Excel 365 users that essentially replaces VLOOKUP and HLOOKUP. It is very easy to dissect the contents of a cell in Excel ...