split column in excel 2010

You should now be able to drag the fill handle (the square in the bottom right corner of the cell) down as far as you would like, in order to merge the remaining information.
C1 column, the space would produce "John Smith" in the empty column, as opposed to "JohnSmith".Using the Query Editor ribbon menu Select the column you want to split.Right-click again on the selected data, click.On the Split Text pane, configure the following options: Expand the Split by string group, and type a comma and space on separate lines.In the Split a column by delimiter dialog box: In the Select or enter a delimiter drop-down, select Colon, Comma, Equals Sign, Semicolon, Space, Tab, or Custom.This formatting will be the same for the whole merged column though.Select the column you want to split, navigate.Let's see how each scenario works: Split delimited text strings, suppose, you have a list participants invited to a conference or some other event.The number of characters in the specified cell.At this point, the appropriate columns should have been game maker pro 8.0 merged.D 1 State, Abbr., Capital State Abbr.The following video shows the Query Editor window appearing after editing a query from an Excel workbook.
For those who are interested to know what the formulas actually mean, I'll try to explain in more detail: search or find function.