Catalog

How to Divide in Excel Cells: 2 Simple Methods

August 3, 2023 1.7K views

In our daily data handling tasks with Excel, knowing how to divide value in excel cells is essential to uncover valuable insights. However, many users struggle with this operation. In this article, we'll guide you through two effective ways of dividing values in Excel and how to split cells to process data easily.

Part 1. Dividing in Excel Cells with 2 Methods

In this section, we will explore two straightforward methods to divide in Excel. Learn how to efficiently divide by numbers and percentages with easy-to-follow tutorials and examples.

#1. Using a forward slash (/) to divide number/percentage

1. Dividing by Number:

To divide cells by a specific number in Excel, follow these simple steps:

Step 1: Open your Excel spreadsheet and select the cell you want to divide by the number.

Step 2: In a new cell, enter the formula "=CellReference/Number", where "CellReference" is the reference to the cell you want to divide, and "Number" is the value you wish to divide by. For example, if you want to divide cell A2 by 5, the formula will be "=A2/5".

Step 3: Press "Enter," and Excel will automatically display the result of the division.

2. Dividing by Percentage:

To divide cells by a percentage, follow these steps:

Step 1: Select the cell you want to divide by the percentage.

Step 2: Enter the formula "=CellReference/Percentage", where "CellReference" is the reference to the cell you want to divide, and "Percentage" is the percentage value you wish to use. For example, to divide cell A2 by 20%, the formula will be "=A2/20%".

Step 3: Press "Enter," and Excel will calculate the result of the division.

#2. Using the QUOTIENT Function:

The QUOTIENT function in Excel allows you to divide cells using a formula. Here's how:

Step 1: Choose the cell in which the outcome should appear.

Step 2: Enter the formula "=QUOTIENT(Numerator, Denominator)", replacing "Numerator" with the reference to the cell you want to divide and "Denominator" with the reference to the cell containing the divisor. For example, to divide cell A2 by B2, the formula will be "=QUOTIENT(A2, B2)".

Step 3: Press "Enter," and Excel will display the quotient.

Master these two methods for dividing cells in Excel, and you'll have the tools to perform efficient data calculations and analysis.

Part 2 : How to Split a Cell to Form a New Column?

Often, data in Excel may be combined within a single cell, making it challenging to analyze or manipulate effectively. By splitting a cell into separate columns, you can organize and extract valuable insights from your data. Here's a step-by-step guide on how to split a cell to form a new column:

Step 1. Choose the cell that you want to divide.

Step 2. Go to the "Data" tab in the top menu.

Alt tag: Data tab

Step 3. Click on "Text to Columns" in the "Data Tools" group.

Alt tag: Text to Columns tool

Step 4. Choose the method to split the data: "Delimited" (using specific characters) or "Fixed Width."

Step 5. Follow the on-screen instructions and preview the results.

Step 6. Click "Finish" to complete the split.

Now your cell data will be divided into separate columns, allowing for better data organization and analysis.

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

Part 3: A Free Alternative Choice——WPS Office

Discover WPS Office, the perfect free alternative to traditional office suites. With WPS Office, you get a powerful all-in-one software that not only meets your productivity needs but also enhances your efficiency.

Emphasizing WPS Office's key features and advantages:

  1. Strong Compatibility: Easily work with Word, Excel, and PowerPoint files, as WPS Office seamlessly supports various file formats.

  2. AI Services: Benefit from built-in AI services that automate tasks and enhance work efficiency.

  3. All-in-One: WPS Office combines word processing, spreadsheets, and presentations in a single software suite.

  4. User-Friendly: With an intuitive interface, WPS Office is easy to use for all skill levels.

  5. Merge and Split Cells: Conveniently merge and split cells in WPS Writer for better data organization.

  6. Versatility: Access WPS Office on Windows, macOS, Android, and iOS devices.

  7. Lightweight: Occupying minimal memory, WPS Office ensures smooth performance.

  8. Regular Updates: Stay up-to-date with frequent software updates for the latest features.

  9. Online and Cloud Support: Access and sync documents across devices with online and cloud support.

  10. Multilingual Support: WPS Office caters to users worldwide with support for multiple languages.

FAQs

1. How do I unmerge cells in Excel?

To split a cell in half in Excel:

Step 1. Choose the cell that you want to divide.

Step 2. Go to the "Home" tab.

Step 3. Select “Merge & Center” from the menu.

Step 4. Then, click on the "Unmerge Cells" button.

The cell will be split for better visibility and organization.

2. How do I split text in a cell in sheets?

For a simple text split in Excel, you can use the "Text to Columns" feature. Here's a step-by-step guide:

Step 1. Select the cell or range of cells containing the text you want to split.

Step 2. Go to the "Data" tab on the Excel ribbon.

Step 3. Go to the “Data Tools” group and select “Text to Columns.”

Step 4. Select “Delimited” from the drop-down menu in the “Convert Text to Columns Wizard,” then click “Next.”

Step 5. Select the delimiter that separates your text (e.g., Comma, Tab, Space, etc.) by ticking the appropriate box. You can see a preview of how the data will be split in the Data preview section.

Step 6. Click "Next."

Step 7. Choose the data format for each column (or leave it as "General"), and optionally set column data formats.

Step 8. Click "Finish."

Excel will automatically split the text in the selected cell(s) into separate columns based on the chosen delimiter.

Summary

The article provides valuable information on how to perform specific tasks in Excel, such as dividing in cells with two methods and splitting cells to form new columns. Additionally, it highlights WPS Office as a free alternative, emphasizing its strong compatibility, AI services, and features like merging and splitting cells in WPS Writer. Users can benefit from WPS Office's user-friendly interface, regular updates, and versatile online and cloud support. Overall, the article offers practical tutorials and emphasizes the advantages of using WPS Office for efficient and cost-effective office productivity.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.