Extract 10digit string based on consistent leadin digits
I have a number I'm trying to extract from a column and I can't figure out how. The number is *always* 10 digits, *always* starts with 50000, and can appear *anywhere* in the cell in Column A (start, middle or end).
Column A has a mockup of the type of data I'm working with. The Result column shows what I want to achieve: a 10digit number based on the 50000##### number located anywhere in Column A.
I know I need to use FIND, and I've looked at similar Q & A in the Community, but can't land on an answer. Thoughts? Thanks!
Best Answer

Hi @Alex888,
As long as "5" doesn't appear in the words prior to the digit of numbers, you could use this:
 =MID([Column A]@row, FIND("5", [Column A]@row), 10)
Hope this helps!
Best,
Zach Hall
Training Delivery Manager / Charter Communications
Answers

Hi @Alex888,
As long as "5" doesn't appear in the words prior to the digit of numbers, you could use this:
 =MID([Column A]@row, FIND("5", [Column A]@row), 10)
Hope this helps!
Best,
Zach Hall
Training Delivery Manager / Charter Communications

Thanks!! That was just what I needed to get straight  my final formula I'm using (to only use 50000 numbers and to make to value is): =VALUE(MID([Column A]@row, FIND("50000", [Column A]@row), 10)) Thanks, again!!
Help Article Resources
Categories
Check out the Formula Handbook template!