Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page delete last number in each cell delete last number in each cell
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2017, 02:50 AM
xor xor is offline delete last number in each cell Windows 10 delete last number in each cell Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

=mid(a1,1,find("^^",substitute(a1," ","^^",len(a1)-len(substitute(a1," ","")))))
Reply With Quote
  #2  
Old 04-03-2017, 04:39 AM
deciog deciog is offline delete last number in each cell Windows 10 delete last number in each cell Office 2016
Novice
  
Join Date: Feb 2017
Posts: 6
deciog is on a distinguished road
Default
Xor

Excellent formula, helped in my project too

thank you so much

Decio from Brazil - São Pulo - SP
Reply With Quote
  #3  
Old 04-05-2017, 09:51 AM
ewso ewso is offline delete last number in each cell Windows 10 delete last number in each cell Office 2016
Advanced Beginner
delete last number in each cell 		 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
=mid(a1,1,find("^^",substitute(a1," ","^^",len(a1)-len(substitute(a1," ","")))))
thanks xor, that works!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete last number in each cell 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
delete last number in each cell 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 last number in each cell 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 07:20 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft