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-03-2017, 02:50 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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

Reply With Quote