Extract last 4 of numeric string

[stevembe]

Grateful as ever for assistance from anyone. A snippet of Column A in my spreadsheet looks like this:

2511</SPAN>

3716</SPAN>

9732</SPAN>

32153</SPAN>

33529</SPAN>

70921</SPAN>

08001174</SPAN>

08002101</SPAN>

08003716</SPAN>

08004693</SPAN>

08004918</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

As can be seen there are numeric strings varying in length. Is there a way I can put a formula in Column B that will only pick up the last 4 digits of all the values in Column A?

 

[Jonmo1]

Try this assuming all numbers will be at least 4 characters

=RIGHT(A1,4)+0

 

[VoG]

Try

=RIGHT(A1,4)+0

 

[stevembe]

Thank you both, that works perfectly, much appreciated, enjoy your day!

 

[Jonmo1]

Glad to help, thanks for the feedback.

FYI, Now that I've looked at it, it doesn't actually matter if the numbers are at least 4 digits.
It will still work even if it's only 1 2 or 3 digits.
It will however error on a blank cell, or a cell with text values.