1-------2-b0-40810

The hyphen between 1 and the second piece; represent real hyphen or some
other text values..Could you post the actual data or confirm whether the
samples posted are the real ones.

--
Jacob (MVP - Excel)


"JJ" wrote:

I need help please. How do I go about to seperate data in one cell ex:
A1
1-------2-b0-40810
A2
2-----------1-03-0060

I typically want to seperate cell A1, 1------from 2-b0-40810 and
cell A2, 2------from 1-03-0060.

Tx