delete last number in each cell

		Microsoft Office Forums > Microsoft Excel > Excel
delete last number in each cell

04-05-2017, 09:51 AM

ewso

Windows 10 delete last number in each cell

Office 2016

Advanced Beginner

Join Date: Nov 2016

Posts: 80

Quote:

Originally Posted by xor

=mid(a1,1,find("^^",substitute(a1," ","^^",len(a1)-len(substitute(a1," ","")))))

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:17 PM.