delete last number in each cell

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

04-03-2017, 02:50 AM

xor

Windows 10 delete last number in each cell

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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

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 10:18 PM.