Originally Posted by Shaun

Need some help with this formula

=IF(BF7="","",IF(ISNUMBER(FIND(",",U7)),LEFT(U7,FIND(",",U7)-1),U7))

it checks to see if the cell is a number then it will remove eveything after "," problem is sometimes there is no bet fluctuation so there is just one set of numbers in the cell and it can't find "," so it returns nothing.

I need it to return the number in cell U7 if it can't find ","