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
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
