To separate first name and last names:
1. Select Column A or the range of cells containing the list of names.
2. From the Data menu, select Text to Columns.
3. In Step 1 of 3, select Delimited.
4. In Step 2 of 3, select the Space checkbox.
5. In Step 3 of 3, in the Destination box, select cell B1, and then click Finish.
Screenshot // Separating First and Last Names Without Using Formulas
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
It does not solve my problem. ex. I have the following words in a single excel cell 2003. "RAMALINGA(-) NAGAR(-)4TH(-)LAYOUT". I want to make spaces where "(-)" have been marked. How should I? Pls help me.
I have found that when I use the Text to Columns delimit feature and then later paste data Excel will automatically create columns based on the settings used previously. Is there a way to prevent this? The only way I have found is to close and reopen Excel. The problem extends across worksheets.
Put your cursor in the cell to the right of the column you want to freeze. ChooseWindow/Freeze Panes.
How do I freeze a column in Excel (MS 2000) ?
One way to combine two or more text columns is to use the CONCATENATE function. To combine the two names assuming the first name is in cell A1 and the last name is in B1, select cell C1 and type =CONCATENATE(A1," ",B1). The " " between the two cells inserts a space between the first and last name.
"LETS SAY THE FIRST NAME IS IN CELL A1 AND THE LAST NAME IS IN CELL B1 AND YOU WANT TO PUT THEM TOGETHER IN CELL C1
IN CELL C1 TYPE =A1""& &""B1 THEN PRESS ENTER AND COPY PASTE THE FORMULA DOWN TO THE END OF THE LIST OF NAMES. AFTER HIGHLIGHT ALL THE NAMES AND RIGHT CLICK, CHOOSE COPY, THEN RIGHT CLICK AGAIN, CHOOSE PASTE SPECIAL AND CHOOSE VALUES."
Anyone know how to go the other way with this tip? I.E. Put two columns - fist name, last name together in one column.