#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=mid(a1,1,find("^^",substitute(a1," ","^^",len(a1)-len(substitute(a1," ","")))))
|
#3
|
|||
|
|||
Xor
Excellent formula, helped in my project too thank you so much Decio from Brazil - São Pulo - SP |
#4
|
|||
|
|||
thanks xor, that works!
|
|
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 |