Split of row data into different subsequent rows
Closed
caimshah
Posts
1
Registration date
Friday July 11, 2014
Status
Member
Last seen
July 11, 2014
-
Jul 11, 2014 at 06:29 AM
Blocked Profile - Jul 14, 2014 at 03:53 AM
Blocked Profile - Jul 14, 2014 at 03:53 AM
Related:
- Split of row data into different subsequent rows
- Saints row 2 cheats - Guide
- Tmobile data check - Guide
- How to delete a row in a table in word - Guide
- Linux split file into n parts - Guide
- Gta 5 data download for pc - Download - Action and adventure
1 response
1. Select the column in which you have the text.
2. In the Data Tab go to Data Tools and click on Text to Columns.
3. You will get the new wizard. Check the delimited option and click Next.
4. On the left hand side of the wizard select the comma option if the texts are separated be commas or you can select any other delimiter option accordingly.
5. Keep the general option checked on the left. Change the destination cell accordingly and it will separate the entries from the destination cell onward.
URL deleted by moderator
2. In the Data Tab go to Data Tools and click on Text to Columns.
3. You will get the new wizard. Check the delimited option and click Next.
4. On the left hand side of the wizard select the comma option if the texts are separated be commas or you can select any other delimiter option accordingly.
5. Keep the general option checked on the left. Change the destination cell accordingly and it will separate the entries from the destination cell onward.
URL deleted by moderator