Microsoft Office Forums - View Single Post - [Solved] delete last number in each cell

Thread: [Solved] delete last number in each cell

View Single Post

Old

04-05-2017, 09:51 AM

ewso

ewso is offline

ewso uses Windows 10

Windows 10 ewso uses Office 2016

ewso uses Office 2016

Office 2016

Advanced Beginner

The original poster

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