My first field is G2

205,801

I'm trying to get it read:

205

Is this formula correct: =LEFT(G2,SEARCH(",",G2)-1)

It did not work. Thanks again. DaveB

Subject: Formula
From: "Dan E"
Sent: 10/22/2003 9:16:26 AM

=LEFT(A1,SEARCH(",",A1)-1)

Dan E

"DaveB" wrote in message
...
I am trying to delete all numbers to right of ",". Can you
share the code. Thanks in advance.

From:
201,076
15,006
6,985

To:
201
15
7
DaveB