I need to return characters between two dashes in a cell

Options
AWood
AWood
edited 12/09/19 in Smartsheet Basics

Hello!

I need to return characters, whatever the length, from between two dashes in a cell. For example:

Column A

A79-199A-2018

A76-185AK-2017

A77-1000A1-2017

 

And then i would need a formula in Column B to return only 199A, 185AK, and 1000A1. If anyone could help me with this, I would greatly appreciate it. Thank you!

Comments