hi Jacob

I tried it and it works great. Tx, appreciate your assistance.

"Jacob Skaria" wrote:

With data in A1

In B1
=LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},MID(A1,
FIND("-",A1),255)&"0123456789"))+FIND("-",A1)-2)

In C1
=MID(A1,LEN(B1)+1,255)

--
Jacob (MVP - Excel)


"JJ" wrote:

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