| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete numbers in each cell in same column
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
