1. In a blank cell to the right of your data, type what you would like to be merged:

    Excel Flash Fill
  2. Select the cell where you typed and then click Home > Fill > Flash Fill.

    Where is it?

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.