¿How can I separate information from the same cells into different cells in excel?

Question

I have a list of complete names in excel, with first names and last names placed in the same cells for each person. I want to know how can I place last names and first names into separate cells.

Answer 1

-Select the data you wish to parse
-Data | Text to Columns...
-Select Delimited
-Click Next
-Select the delimiter (usually space in this situation)
-Click Finish

Answer 2

i visit't contact upon the macro, yet i visit contact upon the approach. initially, there is not any favor to type in the call of each and every sheet. In a cellular on the carry close sheet, type = then click on the tab you want, then click on the cellular you want. Then press enter. Excel will fill in the perfect information. ok, you should attempt this 40 cases, even with the indisputable fact that that's a lot swifter than laboriously getting into the call of each and every tab. in fact it might want to take lower than a minute. also this information updates itself in genuine time. So i visit't truly see why you want to repeat the full procedure once performed. Secondly, the applications SUM and typically happening both ignore about sparkling cells. it would not count number what percentage sparkling lines you've between your files, Excel will in elementary words sum or usually happening certainly numbers. wish this helps.

Answer 3

Assuming there is just a Space between first and last:

If the names were in Column A starting in Row 2
In Column B , Row 2 put the function:
=LEFT(A2,FIND(" ",A2,1)-1)
In Column C, Row 2 put:
=RIGHT(A2,LEN(A2)-LEN(B2)-1)

Then copy B2 and C2 down to the length of the list.

If there is a comma beween the names, then replace the " " with "," in B2.

After that, you can select the whole list, Copy it and then PasteSpecial...Values.

That should get it done and It sure saves a LOT of typing over just copying the list twice and editing each name twice, unless the list is only 20 to 30 entries.

Answer 4

The easiest way possible is to copy the entire content in other column (or row as the case may be). Then delete the extra part cell by cell.