I'm using Excel 2010 and have a number of cells that contain *10^9 e.g. 5*10^9, 3.4*10^9 and need to remove the *10^9. Given that there is about 50000 entries I don't particularly want to do it manually but I'm not very saavy with excel and am not sure how to do this. I tried using the find and replace function however when I did this it removed the entire cell content where as I want to keep the number preceeding the *10^9. I'm sure there must be a way to do this but I don't know how! Any ideas or tips? Helllpp!