Greetings all. Let's say I have "AAAA - ABCD" in a cell. I need to extract
only the portion of text after the space after the hyphen. So, from the
example, I would need to extract "ABCD". With TSQL I can do it like this...

REVERSE(SUBSTRING(REVERSE('AAAA-ABCD'),1,4))

Or I can do...

RIGHT('AAAA - ABCD',4)

Are there any functions in Excel that would allow me to do this? In
reality, the field has a variable length before the hyphen, but the string
after the hypen is *always* = 8. Thank you.