View Single Post
 
Old 04-02-2017, 09:32 PM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
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