Excel, custom format
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.
|