Problem: You have first and last name in column A and you want to divide into into two columns, that is first name and last name.
You further find out that in some of names in column A has 3 names, for example “Alaxander Joa Pilata”. In this case you want to combined the first two names as first name and leave the last name as the last name
In Excel 2007, select the column you want to break, in this case column A. Make sure column B and C (that is column next to it) are empty. Goto Data tab in ribbon menu and select Text To Column in “Data Tools” section. Follow the dialog boxes. Select space as delimiter. This will effectively break your column in two or three column depending on how many names
Solving the three names problem
Now lets discuss the three names problem. We are going to use three excel functions to address this problem
is used to join the join the contents of Cell B and C. Do not forget to add the space in between.
is used to check if the value is a text. It returns for true if it is text, false if it is not text. Remember that it check false for numbers also!
If function take 3 argument, first it true or false, second value if true, third value if false
=IF(condition, this value if true, this value if false)