Extracting a number from a cell

[pauldaddyadams]

Hi,

I have a series of cells where I need to extract a number but my text is not consistant e.g.
ETL_UK_Property_1010285_4
ETL_UK_Property_1010285_7
ETL_1010376_16
ETL_UK_Property_2500001_1
ETL_UK_Property_3400011_6


Is there a formula which would look for a 7 digits a extract the number as per the example.

Regards

Paul

[63falcondude]

Try this in B2:

=SUBSTITUTE(LEFT(RIGHT(A2,10),8),"_","")+0

[pauldaddyadams]

This is fantastic - thank you!!!

[63falcondude]

You're welcome. Happy to help.

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.