Search : in
By :

Regular epression in excel

Last answer on Apr 20, 2009 5:02:38 pm BST simplyme7, on Apr 16, 2009 3:26:03 pm BST 
 Report this message to moderators

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

Configuration: Windows Vista
Internet Explorer 7.0
microsoft excel 2007

Best answers for « regular epression in excel » in :
Spreadsheets - The Excel Interface Show Excel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
VBA: Finding Hdc in an Excel worksheet or UserForm Show VBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
Unable to initiate a DDE link with Excel Show Unable to initiate a DDE link with Excel During an attempt to email of a excel sheet, Microsoft word display a message that it is unable to initiate a DDE link with Microsoft excel. To solve out this problem, save the excel sheet...
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ... for...
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Ask your question Reply

1

 Excelguru, on Apr 20, 2009 5:02:38 pm BST
  • +1

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.

   
Reply to Excelguru
Ask your question Reply
They need your help