How can I show only part of a list of characters in the next cell?

[fredqwerty]

I don't know how to explain this so I shall try to show it below. I have a list of characters in A but only want to show the last 7 characters in B



---A---------------------B
1--rhsyn/sh-st------n/sh-st
2--jsjsurds-vm------urds-vm

 

[JoeMo]

I don't know how to explain this so I shall try to show it below. I have a list of characters in A but only want to show the last 7 characters in B



---A---------------------B
1--rhsyn/sh-st------n/sh-st
2--jsjsurds-vm------urds-vm

In B1 and copy down:
=RIGHT(A1,7)