and you want Excel to identify their languages. and press Enter. Then, use the fill handle to copy this formula to cells B2 and B3. Column B now contains the language codes for each of these ...
drag the Fill Handle to duplicate the formula for remaining cells. Once combined, you need to change the merged data to ...