Pull number at end of text

[NormChart55]

Hello,

I am trying to pull a specific number from the end of data in a row. The problem is that the character length is not always the same. So trying to use =RIGHT() and pull that can pull extra characters, etc. I am trying to find a way to pull just the data that is there through the end. Example below.

example
Store Name City State Store Number - (Best Store Best City Best State XC5559a)

Need Store Number which varies each line -> XC5559a from the above example.

Store number always starts with "XC" and is the only time that shows in the data but can have 4,5,6, etc. characters after

Any thoughts on a formula to grab that successfully?

 

[Fluff]

How about

=SUBSTITUTE(MID(A2,FIND("XC",A2),100),")","")

 

[NormChart55]

How about

=SUBSTITUTE(MID(A2,FIND("XC",A2),100),")","")

Works perfectly! thank you so much for the quick help.

 

[Fluff]

You're welcome & thanks for the feedback.