|
|
#1
04-02-2017, 09:32 PM
|
|||
|
|||
delete last number in each cell
I have a column where each cell has three numbers like this...
cell 1: 13 45 24 cell 2: 24 565 64 cell 3: 35 766 32 ....I need a way to automatically remove the last number in each cell, so that it looks like this.... cell 1: 13 45 cell 2: 24 565 cell 3: 35 766 Can I do this? thanks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Read Cell For number and delete dups
|
jrfoley3 | Excel Programming | 1 | 02-07-2017 05:03 PM |
| Data validation,force cell to be filed with number if respective cell is not empty | nicholes | Excel Programming | 0 | 08-01-2015 09:08 AM |
|
Entering a number in a cell causes it to fill with the color of a nearby cell
|
Bill Martz | Excel | 1 | 04-23-2015 07:57 PM |
|
Delete starting number *) and delete Unneeded data in series
|
frustrated teacher | Word VBA | 5 | 12-07-2014 06:53 PM |
| How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |
Windows 10 
Office 2016
Threaded Mode