Mid Function Usage

[John Davis]

Hello All:

I have the following data in a cell (the dashes are included):

0000033733 - NYKU7904349 - 021012

What I need is two separate cells

Cell 1 would have 33733
Cell 2 would have NYKU7904349

I know this would require the MID Function, but I don't know how to set it up.

 

[Norie]

Why not use Data>Text to columns... with - as the delimiter?

 

[John Davis]

Why not use Data>Text to columns... with - as the delimiter?

Bingo!!! Thanks Norie.