Forum Discussion
MAddesign
Oct 25, 2022Copper Contributor
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.
- OliverScheurichGold Contributor
- MAddesignCopper ContributorThere's other numbers and text in the cell, will it still work?
- OliverScheurichGold Contributor