Hello,

In cell A1 I have the following:

L2D376 - COE

I would like to break up this data into two cells.

In Cell B1 I would like L2D376 to show

In Cell C1 I would like COE to show

I do not need the - at all.

Thanks for the help.
Jim