What feature can you use to populate B2:B7 with the number from each sectence in A2:A7?
Text to columns
No Excel feature can accomplish this; this is possible only using formulas.
Flash Fill
Merge cells
