Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
See more

1 reply

Answer 1 / 1
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
Thank you

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

CCM 2942 users have said thank you to us this month

Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!