Forum Discussion

MAddesign's avatar
MAddesign
Copper Contributor
Oct 25, 2022

Looking to extract specific data from a cell

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.

Resources