A dialogue box will pop up that says “Convert Text to Columns Wizard”. In Excel, click on “Text to Columns” in the “Data” tab of the Excel ribbon. If you wish to separate this information into two columns - first_name and last_name - you can delimit the values using the space as the delimiting character. Imagine you are analyzing responses to the survey question, “What is the name of the household head?” and the responses include both the first and last name of the household head separated by a space. Delimiting Dataĭelimiting data is helpful to automate data segregation. Delimiting and concatenating are two simple operations that will help you manipulate your data and make it ready for analysis. Once your data is structured and cleaned at a basic level, you may need to carry out a series of functions across your data set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |