Trying to pull out a number from a load of alphanumeric characters.
Example of the cell data: Boundary Walls Replaced 2007-08 Gates and Shed Doors Renewed 2008-09; Referenced from 100012345678 Re-roofing 2001.
Issue is that there are several numbers in the cell and I only need the 12 digit number, in the example above I need the 10012345678 number extracted. I have 2500 lines of data and each line has a different 12 digit number in different places within the cell. I have tried several array formulas I've found on this site however they find the first number in this case 2007 and also bring back text.
I'd appreciate any help on this
Thanks
Sue
Bookmarks