Looking to extract specific data from a cell

Copper 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

@MAddesign 

You can try Flash Fill.

flash fill.JPG

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

@MAddesign 

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