Breaking a word down

[j4ymf]

hello

Im doing some work with some stores stock and our material srting looks like this.

CLIP:O,SIZE 14
SCR,CAP:M10,80mm,SOCKET HEAD,12.9
DIE,PRODUCT:MDS-3434
DIE,PRODUCT:MDS-3436
DIE,PRODUCT:MDS-3435
SCR,CAP:1/2"UNC,1.1/2",SOCKET HEAD,12.9
NUT,HX:FULL,M16,HIGH TENSILE
BLT:HIGH TENSILE,M16,80mm
DIE,PRODUCT:MDS-12951
SCR,MACH_SET:3/8"UNC,3/4",HEX,S/STL


im looking to break down the list, how do i shorten the list to the first semi coley :


CLIP:
SCR,CAP:
DIE,PRODUCT:
DIE,PRODUCT:
DIE,PRODUCT:
SCR,CAP:
NUT,HX:
BLT:
DIE,PRODUCT:
SCR,MACH_SET:





many thanks jason

 

[VoG]

Try

=LEFT(A1,FIND(":",A1))

 

[j4ymf]

thank you VoG

you are a star once again

jason