Remove Text from Right
=--LEFT(A1,SUMPRODUCT((LEN(A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},"")))))
© Copyright
andrewsexceltips.net
All Rights Reserved.