Have column A SHEET 1 which is 50 rows. Column A is populated with numeric SNs of 6 to 8 digits in length (none have leading zeros and are text formatted.) The cells may have from 1 to 20 serial numbers in each cell, separated by one space. There are no duplicate SNs. I would like to get all the serial numbers put into a single column in SHEET 2 column B with only one SN in each cell.

Example of contents of two cells from column A:

Cell A1: 32229236 38227217
Cell A2: 6257290 6417295 6219291 6217293 6217288 6217300

Warning - I'm not a programmer.

Thanks for any guidance on a solution.