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.