Niste registriran korisnik
Izaberite jednu od opcija
1. Lajkajte stranicu na linku ispod ili kliknite zatvori ako ste već lajkali.
2. Registrirajte se.
Registracija
Post će se otvoriti nakon što izvršite opciju.

Lapan

Loading...

Lapan

Register
Learn more about computers, laptops, and phones, find out news from the world of technology, watch videos and listen to music, and much more!
Join now, click here!

- Premium - Computers - Desktops - Excel - Laptops - Microsoft Office - Other Computer Software - Software - November 26, 2022

How to split Excel cells using the Text to Columns function

Text to Columns is a phrase used by Microsoft Excel when data in a cell has to be divided into numerous columns.
For example, if cell B1 in Excel has the name “Edna Doe” (first and last name), Text to Columns may divide the text to display in numerous columns.
This article describes how to make advantage of this functionality.

Split Cells in Excel by using Text to Columns

Follow the instructions below to learn how to utilize the Text to Columns tool in Excel.

  1. In Microsoft Excel, open the spreadsheet that requires data reorganization.
  2. Make sure there are the same amount of empty columns to the right of the column holding your data as words in your first column.
    If the first column has the name “Edna Doe,” for example, you’ll want two blank columns to the right.
  3. Select the cells in the column that you wish to utilize.
  4. Click the Data tab in the Ribbon, then the Text to Columns option.
  5. Click Delimited, then Next if all names or data have the same delimiter (Space, Comma, etc.).
  6. Choose the appropriate selection from the checkboxes on the Convert Text to Columns Wizard window based on your delimiter.
  7. The next screen shows a Data preview of your data once it has been transformed.
    If your data is correct, you now have two possibilities.
    If you need to keep the old column and create two new columns for the first and last name, change $B$1 to a separate cell under Destination.
    For the purpose of this example, you can make it $C$1.
    If you don’t mind having the original data erased, leave all choices at their default values.
  8. Finally, click Finish.

Split Cells in OpenOffice Calc and early Excel versions

The procedures to combine cells in Microsoft Excel and OpenOffice Calc are listed below.

  1. Launch Calc or Excel.
  2. Select the combined cell that you want to divide.
    A combined cell becomes numerous columns or rows.
  3. In the formatting bar, click the Merge cells button.

Users of Microsoft Excel 2000

Unfortunately, with Excel 2000, dividing a cell is not as simple as hitting the combine button as shown above.
Follow the instructions below to divide a cell in Excel 2000.

  1. Select the combined cell that you want to divide.
    A combined cell becomes numerous columns or rows.
  2. Select Format from the drop-down menu.
  3. Select the Alignment option.
  4. Uncheck the Merge cells check box on the Alignment tab.

Using a formula, divide an unmerged cell

  1. In Excel, you can also use the Text to Columns option to divide an unmerged cell.
  2. Choose the cells you wish to divide into two.
  3. Select Text to Columns from the Data tab.
  4. Select the Delimited option in the Convert Text to Columns Wizard to separate the text in the cells depending on a comma, space, or another character.
    Select the Fixed width option if you wish to split the text depending on a certain number of character lengths.
    Then, press the Next button.
  5. Select the character you wish to use to separate the data for the Delimited option.
    Select where you wish to split the text for the Fixed width option by clicking in the Data preview portion of the Wizard window.
    Then, press the Next button.
  6. Finally, choose any special text formatting settings for the divided text.
  7. After that, click the Finish button.

Share this with your friends...