How to separate ; in Excel

Apr 11 2014 2:35 AM

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

Answers (2)