Splitting a cell based on dashes

[randrze2]

Hello,

I have the following situation. I have a column of cells that have the first part of the cell (ID number) separated by a dash but occasionally within the latter part of the cell there exist other dashes in the description. I was wondering how to get the description part that is just after the first dash. I've tried TRIM and some other functions to no avail. Example below. Thanks for you help!

Original	Desired Output
123 - Apple-Cider Juice	Apple-Cider Juice
2244 - Yellow-Cheese - 12oz	Yellow-Cheese - 12oz
55A - Regular Coffee	Regular Coffee

<tbody>
</tbody>

 

[Jonmo1]

Assuming there is ALWAYS a space after the first hyphen,

Try
=MID(A2,FIND("-",A2)+2,LEN(A2))

 

[Rick Rothstein]

This will work whether the first dash is surrounded by spaces or not...

=TRIM(MID(A1,FIND("-",A1&"-")+1,99))