Regular epression in excel

Closed
simplyme7 Posts 1 Registration date Wednesday 15 April 2009 Status Member Last seen 16 April 2009 - 16 Apr 2009 à 10:26
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 20 Apr 2009 à 12:02
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
Related:

1 response

Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
20 Apr 2009 à 12:02
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.