Click OK to save the changes and close the dialog boxOn the Formulas tab, in the Defined Names group, click Define Name In the New Name dialog box, in the Name box, type the name you want to use for your reference Note Names can be up to 255 characters in lengthBesides formula, you can use the Defined Function to extract initials from specified names easily in Microsoft Excel 1 Select a cell of the column you want to select and press Alt F11 to open the Microsoft Visual Basic for Applications window 2 In the popup window, click Insert > Module, then paste the following VBA code into the module
Excel Names And Named Ranges How To Define And Use In Formulas
