Grateful as ever for assistance from anyone. A snippet of Column A in my spreadsheet looks like this:
<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?
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?