In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Mar 12, 2017  I have Excel for Mac 2011. Version 14.4.1 (140326) I have an iMac desktop running OSX 10.8.4 (Mountain Lion). I have a Nikon D100 camera. I have no head for numbers. My worst subject in school. I’m surprised that I have learned to do the things in Excel that I have.

Sometimes your Excel spreadsheet contains duplicate data. Excel offers a feature that will scan for and remove duplicated values. Important things to know: • When you remove duplicate values, only the values in the range of cells or table are affected.• Any other values outside the range of cells or table are not altered or moved.• Because you are permanently deleting data, it's a good idea to copy the original range of cells or table to another worksheet or workbook before removing duplicate values.

• When you remove duplicate values, you permanently delete duplicate values. Image from: http://www.nedarc.org/tutorials/analyzingData/cleanTheData/determineCurrentDesiredQualityLevels.html.

I've imported some data into Excel (from a text file) and it contains some sort of newline characters. It looks like this initially: If I hit F2 (to edit) then Enter (to save changes) on each of the cells with a newline (without actually editing anything), Excel automatically changes the layout to look like this: I don't want these newlines characters here, as it messes up data processing further down the track. How can I do a search for these to detect more of them?

The usual search function doesn't accept an enter character as a search character. In Excel the standard line break Alt + Enter character is ASCII 10. From the look of your screenshot it appears there is another character, probably ASCII 13. To find these, in the standard Find (or Replace) dialog, in the Find What field, use the standard method of entering ASCII character codes: hold down Alt and type (on the numeric keypad) the character code, i.e., Alt 0010 for just the line break, or Alt 0013 (release Alt and press again) Alt 0010 If that extra character is not a ASCII 13, you can use the function =Code(AString) to get the code of the left most character of a string. The mid() function can parse through multiple lines. Let's say this address is in cell A1: Google, Inc.

How to use templates in word. 1600 Amphitheatre Pkwy Mountain View, CA 94043 Let's grab the street address on the second line. The first step is determine the position number of the two return characters. The first return character is found at '13' with this: =SEARCH(CHAR(10),A1) The second return character is found at '36' with this: =SEARCH(CHAR(10),A1,SEARCH(CHAR(10),A1)+1) Now the second step.

We need to return our address text between the two character counts 13 & 36. Here the formula is nested together: =MID(A1,SEARCH(CHAR(10),A1),SEARCH(CHAR(10),A1,SEARCH(CHAR(10),A1)+1)-SEARCH(CHAR(10),A1)).