Regular epression in excel [Closed]

Report
Posts
1
Registration date
Wednesday April 15, 2009
Status
Member
Last seen
April 16, 2009
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!