In the final step, we can format the content. So, we’re going to remove the check from the “Tab” and add a check to the “Space” option. In our simple example data, the first and last names are delimited by a space. In the second step, specify the delimiter character. (We’ll talk about the fixed width option in the next section.) That’s the one we’re going to choose here. Delimited means the different pieces of text you want to pull apart are separated by a special character such as space, comma, or slash. Step one is to specify how the content is separated. This opens a wizard in which you’ll perform three steps. Next, select the range of cells containing the names and then click Data > Text to Columns
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |