For those with Windows (or ), Corel still makes a version of WordPerfect for the PC, priced at $100 for the edition; can be downloaded from the company’s site. Microsoft word perfect for mac. If you are not concerned with privacy or uploading documents, free file conversion sites like or third-party conversion services are around.

How to evaluate a nested formula one step at a time in excel 2011 for mac? Hi all, It's all in the title. Java compiler editor for mac. This thread is locked. EXCEL 2011 for MAC: I know this has been asked before. We need a method to select multiple drawing objects, as was possible in previous Excel versions. On important spreadsheets, having many tens of.

Hello, I am trying to merge multiple cells into one cell using semicolons to separate the information being merged. For example, I would like to take the information from A1-A7 and merge this information into B1 to display: A1;A2;A3;A4;A5;A6;A7 And then merge A8-A20 into B8 to display: A8;A9;A10;A11;A12;A13;A14;A15;A16;A17;A18;A19;A20 And so on and so forth. It is important to note that I am operating on Excel for Mac 2011. Please let me know if there is a formula I can use for this or if there is an add-on that can be purchase for Mac.

Everything I am finding is for Windows. You could try this UDF to concatenate the cells with the de-limiter of your choice I have edited to suit your semi-colon request. Function ConCatRange(CellBlock As Range) As String 'usage =concatrange(A1:A7) 'for non-contiguous cells =ccr((a1:a10,c4,c6,e1:e5)) 'note double parens for non-contiguous cells Dim Cell As Range Dim sbuf As String For Each Cell In CellBlock On Error GoTo fred 'comma de-limited alter to suit If Len(Cell.text) > 0 Then sbuf = sbuf & Cell.text & ';' Next ConCatRange = Left(sbuf, Len(sbuf) - 2) fred: End Function Gord.

I have a table that has 3 columns. Column A is the beginning of the range and column B is the end of the range, while column C has the value the needs to be shown if it falls between the range supplied in column A or B. For example Cell A5 = 0 and Cell B5 = 50,000 then the value in Cell C5 = 2,000,000. Then next row, A6 has 50,001 and B6 has 100,000, then the value in C6 = 4,000,000 and so on. How do I write an IF statement that says if a value in a cell (F5) is between the ranges then return that value in column C associated with that range? I thought this formula would work =IF( F5> A5, C5,IF ( F5> A6, C6,IF ( F5> A7, C7,0 ) )) But what I get is either 0 if I enter in 0 in cell F5 or 2,000,000 for all other values. I don't get 4,000,000 if I enter 50,002 in cell F5 but 2,000,000 [Moved from feedback; correct Office version if necessary].