Function og formula to pull out what's in front of first semicolon

[skarlun]

Hi. i need help to solve a problem. in a column i have these "numbers". How can i in a in a support column make a formula or function that pulls out everything that is in front of the first semicolon?

Column A
6088-144;9;1
6088-144;9;2
6088-1320;9;1
6088-1320;10;1
6088-1320;11;1
6088-1321;1;1
608802017473;31;1
608802017476;3;1
6088-127;7;1
6088-127;8;1

Column B (support column) - result
6088-144
6088-144
6088-1320
6088-1320
6088-1320
6088-1321
608802017473
608802017476
6088-127
6088-127

[Pepe Le Mokko]

Try Data - Text to columns - delimited and use semicolon as delimiter. Select not to import the unnecessary columns

[AndyLitch]

=left(a1,find(";",a1,1)-1)

[:) Sixthsense :)]

In A1 Cell
6088-144;9;1

In B1 Cell

Please Login or Register  to view this content.

Drag it down...

[skarlun]

Thanks a lot.

[skarlun]

works like a charm :-)