Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-02-2017, 09:32 PM
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 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
Reply With Quote
  #2  
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,078
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

=mid(a1,1,find("^^",substitute(a1," ","^^",len(a1)-len(substitute(a1," ","")))))
Reply With Quote
  #3  
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
  #4  
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

Thread Tools
Display Modes


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 12:51 PM.


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