So, I have many cells that contain a number and a word. Is the any function in Excel that will just output the number only. For example, in a cell that contains "100% Buy", I just want the 100% and not the Buy. Any ideas?