Hi,

Am Thu, 2 May 2013 18:19:09 +0100 schrieb hennerby:

SF 17296CCH CALCIUM CHL 0.35KG 0.77LB
SF 17155MMA MALIC 5.442KG 11.998LB

try:
=TRIM(SUBSTITUTE(MID(A1,FIND(".",A1)-1,LEN(A1)-FIND("KG",A1)-2),"KG",))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2