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