Looking to extract specific data from a cell

New Contributor

Hi All,


I'm looking to extract specific data from a lot of cells.

the cells have a lot of text and numbers but within each sell there's a constant in this format

nn x nn in.

the n's represent numbers, the range varies a lot some are single digit some are double and some have decimal fractions.


I'm looking for a way to quickly extract that specific occorunce in all the cells, and place each number in a separate column.


so it would look like this:


A    |   B

nn   |  nn


is it possible? thank you.

3 Replies


You can try Flash Fill.

flash fill.JPG

There's other numbers and text in the cell, will it still work?


If there is still a constant in the format it should work.