Next, to generate a long string of a strong password, you will have to repeat the above formula string multiple times with “ & ” in a go.

When you need to get rid of duplicates in a column, Excel's advanced filtering options will do the trick. This quick walk-through shows how it's done.

Is the Auto Fill button when dragging the fill handle down missing in Excel? We show wyou how to enable Auto Fill in Excel.