help - need to parse a cell

  • Thread starter Thread starter confused
  • Start date Start date
C

confused

I have data in a column coming through as

7200:000000000000

Is there a formula to trim this so that I get all numbers prior to the colon :

Thank you
 
Back
Top