Excel Formula to display all characters after the minus sign 1

[LGMan]

Hi, I currently have cell values that look like 'AB-HOWDOYOU' however I only need to show the characters after the "-" so in this example that would be "HOWDOYOU"
I've been able to get around using a =Right(A2,8) type formula.

However I'd like something more robust in case the next load of data has 9 characters.

Any pointers?

Thanks

 

[1726]

Try: =RIGHT(A2,LEN(A2)-FIND("-",A2))

This will return all the characters after the first - character.

cheers

 

[LGMan]

Thanks for the prompt reply with a useful formula that does exactly what I needed. I've also found the Text to Column option which I can incorporate into a macro if needed.
Cheers