Question

Write steps to split the cell content in multiple lines when the content are bigger than coloum width

Answer 1

Hey dear here is ur answer. Hope it helps. Mark it as brainliest please.
Update browser Ignore
ExtendOffice

How To Split One Cell Contents Into Multiple Columns In Excel?

Supposing you have a list of text strings needed to split every string to multiple column cells by commas as below screenshot shown, do you have any quick tricks to handle it? Now in this article, I can introduce the tricks to help you get it done quickly in Excel.

doc split cell to columns 1

Split one cell contents into columns by delimiter with Text to Columns

Split one cell contents into columns/rows by delimiter with Kutools for Excel good idea3

Split one cell contents into columns/rows by length with Kutools for Excel

Split Cells (Split A Cell Into Multiple Columns To Multiple Rows Based On A Separator Or Fixed Width.)

Go to Download
Free Trial 60 daysPurchase
PayPal / MyCommerce
doc split cell
Recommended Productivity Tools

Office Tab: Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.Try now

Kutools for Excel: 200 new features for Excel, make Excel much easy and powerful, increase productivity immediately.Try now

arrow blue right bubble Split One Cell Contents Into Columns By Delimiter With Text To Columns

In Excel, there is a function called Text to Columns can do you a favor on this problem.

1. Select the cells you want to split, and click Data > Text to Columns. See screenshot:
doc split cell to columns 2

2. In the step 1 of the Text to Columns wizard, check Delimited option, and click Next to go on. See screenshot:
doc split cell to columns 3

3. In step 2 of the wizard, specify the delimiter you want to split based on in Delimiters section, and you can preview the strings are split by the specified delimiter. In our case, we check the Comma only, and we can preview each string is split into three columns. See screenshot:
doc split cell to columns 4

4. Click Next to go to the last step of the wizard, and select a destination range for the output contents. See screenshot:
doc split cell to columns 5

5. Click Finish, and now every string has been split into three column cells by comma. See screenshot:
doc split cell to columns 1

arrow blue right bubble Split One Cell Contents Into Columns/Rows By Delimiter With Kutools For Excel

If you want to get this problem done with a much easier method, you can try to use Kutools for Excel’s Split Cells utility, which can quickly split one cell contents into multiple columns or rows by a delimiter.