Two separate words

[digit]

Hello,
i have a column with a data Like:
Hristo,Vankov
Marty,Hristov
Ivo,Petrov
Hristian,Todorov

So my question is how can i split two names in 2 differnt columns:

[field1] [field2]
Hristo Vankov
Marty Hristov
Ivo Petrov
Hristian Todorov

Thank you and sorry for my bad english

 

[digit]

There is a different types.
I need to separate words where is separated by ","

 

[AlexN]

Try the way shown in the attached file.

 

[MarkK]

Check out the VBA.Split() function.