Extraction from a cell

[Sal Iaccarino]

I have the following in a cell: 2486 Orchid Bay Dr, X102

I would like to keep this cell as it is, however, I would like to extract
the X102 into another cell by itself.

Can someone indicate a formula to do this?

Thanks Sal and Eileen

 

[GerryK]

=RIGHT(A1,4)if it is always in this format.

 

[Sal Iaccarino]

Thanks! Good solution.

Sal and Eileen

=RIGHT(A1,4)if it is always in this format.