How to Split Cells in Excel

When working with Excel, you may encounter many difficulties that will slow down your work. Luckily, there are many Excel tips available online and you can find them and use them very easily. Whereas solutions to common Excel problems can be found quickly, solutions to those less common Excel problems are harder to find. One such difficulty you may experience while working with tabular data is to split cells in Excel. Oftentimes wrong data is placed together in one cell and you need to make more cells in order to split that data.

Unfortunately, there is no such option in Excel that can divide one cell into multiple smaller cells but still, there is a way to split cells in Excel. If you follow the steps below you will be able to divide content and place it in separate cells.

Firstly, select the cells you want to split. By clicking on the Data menu, a toolbar like this one shown on the image below will appear.

split cells in excel

In the Data Tools tab, click on Text to Columns and then on Delimited option. When you click on Text to Columns, a window will show up asking you to choose between Delimited and Fixed Width.

split cells

Then click Next and another set of options will appear.

At the top of the window you will see a set of delimiters options, and you should tick one delimiter  that is the most suitable. You can choose more than one delimer and in that case, tick the box Treat consecutive delimiters as one. The data preview panel shows how the data will look like when it is split in multiple cells.

cells in excel

When you click Next button one more time, you will be able to format column data, by setting up the options in Column data format area.

split cells

When you are done with formatting just click the Finish button.

Additional notes:

If you are working with big data it is required to make a copy of the spreadsheet first and then to split cells in Excel.

If you are asked to replace the content of destination cells, cancel that operation, select different delimiter and modify data in the original column.

No matter how often do you work with Excel, learning new Excel skills can only help you with data analysis and other data manipulation tasks.

 

 

 

 

How to Add Page Numbers in Word

Many Microsoft Word users don’t know how to add page numbers in Word. Even if they knew how to insert numbers, the problem arises when a document would have the introduction or a table of contents. That first introductory part of the document shouldn’t include numbers which means that a user must skip a couple of pages at the beginning. Since Word has automatic number labeling, a user must set up page numbering manually.

The following guide applies to Word 2016, 2013, 2010 and 2007. First, we will show you how to add page numbers in Word and then we will share with you some advanced techniques.

 

Guide 1: How to Add Page Numbers in Word

 

First, open the exact page in the document from where you want to start page numbering. Then click on Insert menu and then on Page Number option in the Header & Footer tab.

insert page number in word

You can have a closer look at the Page Number option, on the image below.

how to add page numbers in word

 

You can add page numbers at the top or bottom of the page, page margins or from the current position. For instance, if you click on Top of Page, a wide range of numbering styles will appear and you need to choose from one of these.

 

Guide 2: Add Page Numbers in Header or Footer

 

If the header or footer of your document contains text such as the name of the book chapter or the head name and you want to add page numbers as well, the above guide won’t be of any help. For that purpose, you need to apply a bit complex settings.

First thing first, double mouse click on the header of footer area and the Design menu will open. Click on it and then in Position tab, select Insert Alignment Tab.

header and footer tools

 

You can place your numbers on the left, right or centrally. Below is shown how the Alignment Tab looks like.

 

add page number

 

Don’t close the Design mode but select the Quick Parts option from the Insert tab. Choose Field option.

 

quick fields

 

In the field name find the Page and then in the Field properties choose the proper number formatting.

 

page number formatting

 

Click OK and then close the Header and Footer tools.

 

Guide 3: Set up Page X of Y Format

 

Follow the guide 1 to insert page numbers and upon choosing the location where you will put the numbers, choose the style. One of the styles is Page X of Y which offers three different types of bold number.

If your header or footer contains additional text, you need to follow the guide 2 and upon opening the Quick Parts tool and Field option apply these steps below:

Under the Field names list, choose NumPages name and then click OK.

From the Header & Footer tab, select Format Page Numbers and then choose the preferred format of numbers.

 

choose number format

 

Guide 4: Use Different Numbers Formats in the Same Document

 

Follow this guide if you want to use different number formats such as i, ii, iii and 1, 2, 3. Click on the page in the document where you want to start page numbering with different format.

From the Layout menu, in the Page Setup tab, select the Breaks option.

In the Section Breaks click on Next Page and then double click in the area where you want to insert a number.

The Design tab will open again and this time, you should click on Link to Previous button. By doing so, you will unlink the page numbering from a previous section and this part of the document will have different page numbering.

To set up the new format of page numbering, just follow the guide 1.

 

Start Page Numbering with Different Number

 

In some cases,  you may want to use some other number as a starting number and not the number 1. Following these steps to start page numbering with a different number:

Click on the Format Page Number option in the Header & Footer tab.

In the drop-down menu Start at, type the number you want to be your starting page number.

 

page numbering in word