DataMystic

With a full name consisting of 2 words, it is not very difficult to split a name in first and last name. It get difficult with three or more words, because you need to understand the words.

if there is a hyphen (Mary-Ellen, Johnson-Leboeff), the 2 connected words should be considered one.
if there ...

Suppose you have this layout

5 figures<tab>word word word, word, word, word,word<tab>word<tab>

Now I want to split the second column into 2 columns. The seperator is left most comma in the second column.

So far I would do this in Excel (to get the columns right) and Word (to split 1 selected ...