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!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Original[/TD]
[TD]Desired Output[/TD]
[/TR]
[TR]
[TD]123 - Apple-Cider Juice[/TD]
[TD]Apple-Cider Juice[/TD]
[/TR]
[TR]
[TD]2244 - Yellow-Cheese - 12oz[/TD]
[TD]Yellow-Cheese - 12oz[/TD]
[/TR]
[TR]
[TD]55A - Regular Coffee[/TD]
[TD]Regular Coffee[/TD]
[/TR]
</tbody>[/TABLE]
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!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Original[/TD]
[TD]Desired Output[/TD]
[/TR]
[TR]
[TD]123 - Apple-Cider Juice[/TD]
[TD]Apple-Cider Juice[/TD]
[/TR]
[TR]
[TD]2244 - Yellow-Cheese - 12oz[/TD]
[TD]Yellow-Cheese - 12oz[/TD]
[/TR]
[TR]
[TD]55A - Regular Coffee[/TD]
[TD]Regular Coffee[/TD]
[/TR]
</tbody>[/TABLE]