Extracting last four digits

[Cossie]

hello

I am looking th be able to extract the numbers at the end of a string of text. I also need to be able to extract the number regardless of the length of the text in front of it. I need it to be extracted to another cell.


Finance & Admin Services 4100 on this example i need to extract the 4100
System Professional Learning 5306 on this example i need to extract the 5360



Any assistance would be appreciated as usual

 

[Michael M]

Try

Excel 2003
	A	B
1	Finance & Admin Services 4100	4100
2	System Professional Learning 5306	5306
Sheet1

Cell Formulas
Range	Formula
B1	=RIGHT(A1,4)*1
B2	=RIGHT(A2,4)*1

 

[jarjarbingie]

=RIGHT(cell, 4)

 

[Cossie]

Thanks very much

 

[Cossie]

can i add this to this formula?

=VLOOKUP($A3,Sheet1!$A$2:$BD$1200,34,0)

 

[Robert Mika]

can i add this to this formula?

=VLOOKUP($A3,Sheet1!$A$2:$BD$1200,34,0)

Like this?
I wour rather used INDEX/MATCH to avoid such a bif table references:
Excel 2010

	A	B	C	BD
1	5306	System Professional Learning 5306		Finance & Admin Services 4100
2				System Professional Learning 5306
3

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Array Formulas Cell Formula B1 {=INDEX($BD$1:$BD$17,MATCH(A1,--RIGHT($BD$1:$BD$17,4),0))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

or:

Excel 2010
	A	B	C	BD
1	5306			Finance & Admin Services 4100
2		System Professional Learning		System Professional Learning 5306
3
Sheet1

Cell Formulas
Range	Formula
B2	{=SUBSTITUTE(INDEX($BD$1:$BD$17,MATCH(A1,--RIGHT($BD$1:$BD$17,4),0)),A1,"")}
Press CTRL+SHIFT+ENTER to enter array formulas.