Regular epression in excel

Closed
simplyme7
Posts
1
Registration date
Wednesday April 15, 2009
Status
Member
Last seen
April 16, 2009
- Apr 16, 2009 at 10:26 AM
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
- Apr 20, 2009 at 12:02 PM
Hello,

I have 2 questions in excel 2007:

1) I have excel columns with the format

12,4
17,1
8,2
etc..

I want to replace it with only the first number befor the comma, to be like this:
12
17
8
etc..

how can I do this

2) I have the followng

CellA CellB CellC
12 15
10 10

I want the function in Cell C to be 1 if cellA=CellB and 0 if they are not equal
I used in Cell C the function IF(A2=B2;1;0)
but how to extend this function to the whole column? I have 1round 166,300 entry.

Thanks
Simplyme

1 reply

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Apr 20, 2009 at 12:02 PM
Q1. Use formula =LEFT(A1,FIND(",",A1)-1)
Q2. Place your mouse on the lower left corner of C2. Your mouse curser has changed to a Cross(+) sign. Double click.
1