Extract number from string but retain leading zeros

[sharky12345]

I want to extract the numbers from a cell containing a mixed string but I need to retain the leading zeros.

My data consists of the following format:

SD001, SD002 through to SD1790

There will always be the text 'SD' followed by 3 or 4 numerical digits and it's the numerics I need, but retaining the leading zeros.

 

[arthurbr]

Perhaps =right(A1,len(a1)-2)

 

[sandy666]

or SUBSTITUTE()

 

[pgc01]

Hi

If this a a column of values you don't need formulas, you can just select the columns and use text-to-columns.

 

[gaz_chops]

Or

=REPLACE(A1,1,2,"")

 

[arthurbr]

More than one way to skin a cat