Separating First and Last Names Without Using Formulas

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
Separating First and Last Names Without Using FormulasSeparating First and Last Names Without Using FormulasSeparating First and Last Names Without Using Formulas

Users are saying about us...

  1. “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.”

  2. 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.

  3. 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.

  4. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube