Yes,
In the cell in which you wish to extract that data, simply type
=right(a1,6), meaning that excel will look in that cell and from the right
extract all characters from the 6th one in. You can also use the left
function; =left(cell,#_characters). They work precisely the same just
counting from different directions.



"Thyag" wrote:

Hi Friends,

I am in requirement of a formula for extracting only last seven (or
less) numerical digits from a reference.


Ex -
1 - if A1 consists 112233help573847 - I need "573847".
2 - if A1 consists 112233help573 - I need "573".
3 - if A1 consists 112233help - I need "112233".
4 - if A1 consists 112233 - Ineed "112233".


Any help is appriciated.


Thanks,
Thyag