delete numbers in each cell in same column
You can use TTC and not have to use formulas or helper columns.
Select the data in the column, then, from the Menu Bar,
<Data <Text To Columns <Fixed Width <Next,
In the second step of the Wizard, click in the "Data Preview" window to
place the break line between the 2nd and 3rd digits.
Then <Next
In the 3rd step of the Wizard, you'll see that the first 2 numbers are
selected (colored black), and in their own column.
NOW, click on "Do Not Import - Skip", which will skip that selected column
containing the first 2 numbers.
Finally click <Finish, and you're done.
Your numbers, minus the first two digits, are all that remain in the Column.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Anna Huber" <Anna Huber @discussions.microsoft.com wrote in message
...
Is there an easy way to just delete the first two numbers in each cell all
the way down the column? i.e. 123456789 to 3456789? Would I have to
create
a helper column; put in a formula for the removal of the first two numbers
then cut and paste on the column I want to adjust? If so, can you tell me
specifically how to do this and why I am this specific formula to achieve
this action....... Thank you!
|