Formula

[DaveB]

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: Re: Formula
From: "Dan E" <[email protected]>
Sent: 10/22/2003 9:16:26 AM

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

Dan E

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

 

[Felipe]

Dave,

That formula will not work if your data are numbers.

I'm a bit confused, previously you said you wanted 6,985
to become 7, in your last message you say you want 205,801
to become 205

You can use
First option:
=ROUND(G2/1000,0)

Second option:
=FLOOR(G2/1000,1)

Regards,
Felipe

 

[Jason Morin]

=LEFT(G2,3)*1

HTH
Jason
Atlanta, GA

 

[Jason Morin]

Hold up. I just read the rest of the thread. See if this
works.

=LEFT(A1,FIND(",",TEXT(A1,"###,###"))-1)

BTW - don't multipost. Thanks.

HTH
Jason
Atlanta, GA