Flash Fill does not spill as expected.

With the following in Column A

Excel 2016 (Windows) 64 bit

	A
1	Smith, John Allen Mark
2	Jones, Sam James Arnold
3	Roberts, Mick Jon Kevin

Sheet: Sheet1

and Expected Results in Column B

Excel 2016 (Windows) 64 bit

	B
1	Smith, J.A.M.
2	Jones, S.J.A.
3	Roberts, M.J.K.

Sheet: Sheet1

Actual Results when using Flash Fill are not what was expected.

Excel 2016 (Windows) 64 bit

	B
1	Smith, J.A.M.
2	Jones, S.J.O.
3	Roberts, M.J.O.

Sheet: Sheet1

Any thoughts on this. A Bug in O365

Sometimes I have to fill in more than one row of expected results. This is one of those times and it worked. I agree though. Very strange.

Smith, John Allen Mark	Smith, J.A.M.
Jones, Sam James Arnold	Jones, S.J.A.
Roberts, Mick Jon Kevin	Roberts, M.J.K.