Prev: How to arrange data
Next: Rating
From: Jacob Skaria on 19 Apr 2010 07:11
Try the below formulas with the entry in cell A1

=LEFT(MID(A1,20,255),FIND(",",MID(A1,20,255))-1)
=TRIM(MID(A1,FIND(",",A1)+1,255))


--
Jacob (MVP - Excel)


"domyrat" wrote:

> there can be data entered this way also:
>
> AA-BB-999-xxxxx-zz-Abcdefghij Klmno 9-H, PRSTUVW
> AA-BB-999-xxxxx-zz-Abcdefghij Klmno 9-2, PRSTUVW
>
> "domyrat" wrote:
>
> > There is one more problem, that needs help.
> >
> > I got data:
> >
> > AA-BB-999-xxxxx-zz-Abcdefghij Klmno 9, PRSTUVW
> > AA-BB-888-zzzzz-zz-Abcdef Ghijk 8, LMNOPRSTUV
> >
> > In B1 and C1, B2 and C2 i need this:
> >
> > B1: Abcdefghij Klmno 9
> > C2:PRSTUVW
> >
> > B2: Abcdef Ghijk 8
> > C2:LMNOPRSTUV
> >
> > They are not same length.
First  |  Prev  | 
Pages: 1 2
Prev: How to arrange data
Next: Rating