How To Separate Names In Microsoft Excel And Google Sheets

If you’re using Microsoft Excel, you can separate names using the Convert Text to Columns Wizard. Here’s how to use the tool in the desktop app:

  1. Open the Excel sheet and select the column that contains the names you want to separate.

  2. Click on Data at the top and select Text to Columns.

  3. In the Convert Text to Columns Wizard, select Delimited under file type.

  4. Click Next.

  5. Choose the appropriate Delimiters. This could be a comma or space, depending on your formatting.

  6. A preview will show you what the separated names will look like. Click Next.

  7. Next to Destination, click on the arrow and choose the column where you want the separated names to appear.

  8. Click Finish.

If you’re using the free online version of Excel, use this method instead:

  1. Select the column with the names you want to separate.

  2. Click Data and select Text to Columns.

  3. Select your Delimiters such as commas or spaces.

  4. A preview will appear on the screen.

  5. Click Apply.

  6. The names will automatically separate into the selected column and the one next to it.

If there are no empty columns, Excel will warn you that it will replace the text in the column to the right. Therefore, it’s best to make sure you have an empty column next to the list of names to avoid losing any data.

Read original article here

Denial of responsibility! Verticall lobby is an automatic aggregator around the global media. All the content are available free on Internet. We have just arranged it in one platform for educational purpose only. In each content, the hyperlink to the primary source is specified. All trademarks belong to their rightful owners, all materials to their authors. If you are the owner of the content and do not want us to publish your materials on our website, please contact us by email – The content will be deleted within 24 hours.

Leave a comment