office365 – Excel Smart Formatting


Let’s say I have the following values

Column 1               column 2               column 3
Article - John|Doe     Article - John,Doe     John, Doe

I have column 1 in my file. I created column 2 and column 3 manually by hand.

Is there a way to drag the formatting of column 2 and column 3 down to the rest of the rows so that the same idea applies even though Column 1 might have different values? I.e.

Article – John|Smith

Edit:

I actually did this in Excel, but I’m not sure how I did it. All I did was copy and paste some values, but I’m not sure how I can replicate this as it happened by accident.