Page 82 - Excle-En-V3

14.4 - Calculations on More Than Three Worksheets
Sometimes, after writing the full name in one cell, we need to separate the first

name from the middle name, and the last name, and so on. To do this, do the
following:

First, choose the name you want to separate, then go to the Data tab, and choose
the Text to Columns tool, as shown in the following figure:

Figure 116: Select the Text to Columns tool

-Select Fixed width, then Next. The following menu will appear:

Figure 117: Controlling Columns

74 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024