return items after "-" in text string

Pamela.Baron

I have a text string that I need to break down "Order # 000000-L1" I need to obtain only the last items after the "-" which can vary in length so Right formula won't work for me. It could be L111 or LGN1111111

heyjay

Where ORDER is your column name for the order#s

=RIGHT(Order@row, LEN(Order@row) - FIND("-", Order@row))

heyjay

Where ORDER is your column name for the order#s

=RIGHT(Order@row, LEN(Order@row) - FIND("-", Order@row))