Forum Discussion
Solved
Pulling all 10-digit from 1 Cell
Hello All, Need help in extracting 10 digit strings from one cell. Scope is an exported email box and needing to extract all 10-digit numbers from the Subject of the email(is collected within...
=List.Select(Text.SplitAny([Contents],Text.Remove([Contents],{"0".."9"})),each Text.Length(_)=10)
ronrsnfld
Super User
Super UserDepending on the nature of your data, splitting text on a space may or may not return what you need. You could have a problem if there is punctuation after a value. You will obtain better answers if you post some data as text which can be copy/pasted, along with a screenshot of your expected results from that text.