Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Text Manipulation
FIGURE 9.2 The Text to Column Menu Location on the Data Ribbon
FIGURE 9.3 The Text to Column Menu
FIGURE 9.4 Use the Delimited Option
columns is done through the Text to Column menu. Select column A and activate the
menu. See Figure 9.3.
The menu has two options, Delimited or Fixed width. Since this data is
of assorted sizes and it is separated by commas, apply the Delimited option. See
Figure 9.5 shows the data before and after it was separated.