By the second cell, Excel should recognize the pattern and display what it thinks you want. Just hit enter to use them. This works with numbers, names, dates, and more. If the second cell doesn't give ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results