QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Split Text in a Cell in MS Excel 2016?

By Neha T Leave a Comment

In case you have entered some information in a single cell in Excel, and you want to split the text into separate columns then  MS Exel has provided an easy way to split the text in a cell. So let us begin with How to Split  Text in a Cell in MS Excel 2016?

Step to Split Text in a Cell in MS Excel 2016:

Step 1: First select the cells, whose text you want to split. You can observe in the image below; I have a column Name which comprises the full names of the candidate i.e. first name and last name. I want to separate first name and last name.

how-to-split-text-of-cells-in-ms-excel-2016-step-1Step 2: Go to Data tab and under Data Tools group, click on Text to Columns button.

how-to-split-text-of-cells-in-ms-excel-2016-step-2Step 3: A Convert Text to Columns Wizard will open. It has three steps. In the first step under Original data type Section select, Delimited as our text is separated with a delimiter, space. Then click Next.

how-to-split-text-of-cells-in-ms-excel-2016-step-3Step 4: In the second step of the wizard, under Delimiters section I have selected Space as my text has space as a delimiter. In case you want to split on the basis of tab, semicolon, comma or other you can choose likewise.  You can preview, how your text would be separated in Data preview section. Then click Next.

how-to-split-text-of-cells-in-ms-excel-2016-step-4Step 5: First, select the first column in Data preview section and then choose the column data format as my data is text I have chosen Text. Then repeat the same process for all the columns.

Next, click in the Destination box and the collapse dialog box (3) button.

how-to-split-text-of-cells-in-ms-excel-2016-step-5

Step 6: The dialog box will collapse and then select the cell where you want to place your separated text. You will see that the code of the cell will appear in the Destination box. Then click Expand dialog box(3) button. Click Finish button.

how-to-split-text-of-cells-in-ms-excel-2016-step-6Step 7: Here, you can see that Full name and the Last name of the candidate got separated. Align them in the way you want. You can also edit the font, size, colour etc. of the text.

how-to-split-text-of-cells-in-ms-excel-2016-step-7Hope the content is useful. Keep reading.

You Might Also Like:

how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? how-to-sort-data-in-ms-excel-2016-featured-imageHow to Sort Data in Ms Excel 2016? how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? how-to-transpose-in-ms-excel-2016-featured-imageHow to Transpose in MS Excel 2016? Flash Fill in MS Excel 2016How to use Flash Fill in MS Excel 2016? compare two columns in Excel Feature imageHow to Compare Two Columns to Find Matches & Differences in Excel 2016? How to convert text to number in Excel - Featured ImageHow to Convert Text to Number in MS Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016?

Leave a Reply Cancel reply

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

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Disable Javascript in Mozilla Firefox
  • How to prevent others from accessing your home directory in Ubuntu 14.04
  • How to Open Developer Tools in Chrome?
  • How to Translate a Webpage in Google Chrome?
  • How to Enable and Configure Bluetooth in Ubuntu

Copyright © 2023 · QueHow · Contact Us