Unfortunately, we need to do this manually. However, our target is to split these values into two rows.As a result, you will see that the values are split into two columns ( C5 & D5). On the other hand, if you want to replace the text, keep the field as it is. Here in step 3, if you want to place the separated texts in a different location, you can choose the Destination.In my case, the authors’ names are separated by a comma (,). Now, from step 2, select the Delimiters by which your text will be separated.From there, select the file type Delimited and click Next.As a result, a dialog box named Convert Text to Columns Wizard will pop up.Now, from Data Tools, select the Text to Columns option.First, select the cell that you want to split.Hence, we need to manually convert the extracted columns into rows. But we want to convert a piece of text to convert into rows. This feature converts a piece of text into multiple columns. You can use the Text to Columns from the Ribbon to split a cell into rows. Using Text to Columns Feature to Split a Cell into Two Rows in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |