List with names and numbers

[Manena]

Good morning all over the world,
My challenge today is because I found that our accounting program (QB) doesn't show me the costumer contact list without job number.
I need the list only with the plain name without numbers and only one time per customer.
Please see the example:
ZIE SA
ZIE SA:180057
ZIE SA:271520
ZIE SA:271903
ZIE SA:271905
ZIE SA:580019
ZIE SA:580069
ZIE SA:580213
ZIX ASA
ZIX ASA:601729
ZIX ASA:939836
ZIX ASA:939837
ZODIAC Morten
ZODIAC Morten :020297

And I want the list like this:
ZIE SA
ZIX ASA
ZODIAC Morten

Thanks you very much for your attention and the best wishes from the lovely and sunny Miami.

[amotto11]

try this formula in the column next to it, assuming your data is in column A =TRIM(LEFT(A1,IFERROR(FIND(":",A1),LEN(A1)+1)-1)). Then copy and past values and use excels remove duplicates function.

[AlKey]

Or this

=TRIM(LEFT(SUBSTITUTE(A1,":",REPT(" ",50)),50))

[excelcrazy2]

Select the column of data. From the Data tab, click Text to Columns, choose Delimited and click Next>, select Other and type a colon then click Finish.

[Manena]

Excelcrazy2, that was the best solution and most simple. I will give you reputation after I finish my case.
Thanks you very much.
Now, I have a huge list with a lot of duplicates names. I am thinking to do it trough Data, Remove Duplicates. Is it a better way to do it?
Thanks you very much