The length of data of the second section is not all the same. Some are 9
characters long and others are 11 characters long.

Tx.

"JJ" wrote:

Jacob

this is the actual data. you will see from the data that the second piece of
info is not all in line.

tx.

"Jacob Skaria" wrote:

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