Microsoft Office Tutorials and References
In Depth Information
5. Choose the characters you use to separate
your text. In this example, the data is split up
by a space, which separates the first and last
names, so let’s choose space. The preview
area shows you how your split data will
appear (see Figure 11-42).
The Convert Text to Columns Wizard.
6. Click Next.
If necessary, insert blank cells to the left of
the cells you want to split. If you will have
data in three columns, you must have two
If you want any specific format for your
columns—for example, if you had a ZIP code
and you wanted it treated as text instead of
numeric or a date as a specific date format—
select the column you want formatted and
choose a Column Data Format.
2. Select the cells containing the data you want
to split into columns.
3. Choose Data>Data Tools>Text to Columns.
You see the Convert Text to Columns Wizard.
8. Click Finish. Excel converts the data into
separate columns (see Figure 11-43).
4. Select Delimited and then click Next.