ExcelBanter - help - need to parse a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - help - need to parse a cell (https://www.excelbanter.com/excel-worksheet-functions/247093-help-need-parse-cell.html)

confused

help - need to parse a cell

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

David Biddulph[_2_]

help - need to parse a cell

=LEFT(A2,FIND(":",A2)-1)
--
David Biddulph

confused wrote:
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

Teethless mama

help - need to parse a cell

=LEFT(A1,FIND(":",A1)-1)

"confused" wrote:

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

All times are GMT +1. The time now is 02:12 AM.