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 i...

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 column,...