Breaking text on several columns

Very often we meet problem when we need to break down the text on several columns. For example in column “A” is first name and second name together, but we need put them in separate columns.

For this select the cells for breaking and choose in menu Data - Text to columns. Then appear Text wizard window:

At the first step of Wizard we should choose data format. Then we choose if our text have delimiters (gaps, semicolons etc.):

At the second step we choose delimiter. In our case it is gap:

And at the finally step we have to choose format of data:

Press OK and we will receive the next result:

Related articles:

Automatic separation of text on a given delimiter (SPLITUP)
Text concatenation from different cells (CONCATENATE)
Text concatenation by the condition (CONCATIF)
Separation of characters from the text (LEFT, RIGHT, MID)