Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - Splitting data from 1 cell to 2 cells
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
advanced excel training - Splitting data from 1 cell to 2 cells
Resolved · Low Priority · Version Standard
Reply Tue 2 Jan 2007, 11:45Delegate Emma said...
Emma has attended:
Excel Intermediate course
Powerpoint Introduction course
Splitting data from 1 cell to 2 cells
Is there a way to automatically split data contained in one cell into two separate cells?
e.g. we have a column containing data such as:
3145 Object1
3454 Object2
5573 Object3
Is it possible to automatically place this data into 2 separate columns, the first containing the 4digit number and the second containing the related name?
This would save us a huge amount of time rather than having to do it manually!
Many thanks,
Emma
For upcoming training course dates see: Pricing & availability
Reply Tue 2 Jan 2007, 12:48Delegate Tristan said...
RE: Splitting data from 1 cell to 2 cells
Emma
Not sure if it can be done automatically but you can do it in bulk. Select the column with your data in it, then go to the 'Data' menu and select 'Text to columns'. This will then start a wizard that will guide you through it. It gives you a graph showing your data and you simply move a line to where you want to break it up. It will then move everything to the right of that line into the next column. Make sure though that the column to the right is empty otherwise it will overwrite any data already in it.
Hope that helps
Tristan
RE: Splitting data from 1 cell to 2 cells
Use the left function and the riht function in Excel
for example:
=LEFT(A1,4) would only show 3145
=RIGHT(A1,7) would only show Object1
i hope this helps
|