How to separate ; in Excel

Question

Hi everybody,

 

I have a sheet in excel with this:

 

2;De Vries-De Wit;Acaciastraat ;3;6444;CC;Brunssum;9756234512

 

I want to remove the ; and make colums off it, like this:

 

2 = number(colum), De Vries = familyname(column)

 

But how to do this in Excel?

 

Thank you