=LEFT(A1,LEN(A1)-1)*IF(RIGHT(A1,1)="K",1000,IF(RIGHT(A1,1)="M",1000000,1)) Found this on the googles, replace A1 with what you want to be substituted. If you want to maintain the cell you can manually find+replace K\M in selected areas with 000 or 000000. could you guys please be a little more off topic. try using pm It's for the purposes of his excel sheet directly related to this thread lol Exactly. Sadly, your solution didn't work though. I am trying to import GE prices from GE database and make calcs with those numbers. So, it would have to be auto and not manually