Can I use a left or right command but exclude a vairable?

[TWTHOMAS]

I have a list of SSN's that I use to match up to a list of employees in a travel system. Unfortunatley the travel system allows individual users to have two accounts.

One acccount is thier SSN and the other is their SSN with a G at the end.

I would like do something like a =right(A2,4) but I want to ignore any of the G's and get nex to last rightmost 4 on ones that have the G.

The easy way I have found is to do a replace G with backspace but I
really want to completely automate the process.

I don't know much about macros or VBA so I hope someone has a formula variable I can use.

Let's say my list is

123546565
839484736G
837362577G
984838827
762552561
726355262G

I want to get

6565
4736
2577
8827
2561
7262

Thanks in advance.

If I have inadvertantly created a real SSN my appologies.

 

[Jonmo1]

If it's only a G that could be at the end...

Try

=RIGHT(SUBSTITUTE(A1,"G",""),4)

 

[VoG]

Try

=IF(ISNUMBER(A1),RIGHT(A1,4),MID(A1,6,4))

 

[TWTHOMAS]

If it's only a G that could be at the end...

Try

=RIGHT(SUBSTITUTE(A1,"G",""),4)

Worked perfect! Thanks!