Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
To delete paired numbers or pickup last cell for each item | Excel Discussion (Misc queries) | |||
how to delete repeated numbers in a column, make it apears once | Excel Discussion (Misc queries) | |||
HOW DO I DELETE NUMBERS IN A COLUMN out of each cell | New Users to Excel | |||
How do I delete numbers in a cell | Excel Discussion (Misc queries) |