8 Changing the case of text (PROPER, UPPER & LOWER).11 Copying part of a column of text.13 LEFT function to extract text from the left of a cell.13 RIGHT function to extract text from the right of a cell.14 MID function to extract text from the middle of a cell.14 Removing spaces (TRIM function).15 Duplicate entries.17 Conditional formatting to identify duplicates (Excel 2011 only).17 Remove Duplicates (Excel 2011 only).18 Use a formula to identify duplicate entries.19 Copy & Transpose a column to a row.22 Last Updated 15 th July 2015ģ Excel for MAC Text Functions Find and Replace to update multiple entries in one hit If you need to replace all instances of a certain string of text with another, use find and replace: Click on Edit > Replace on the menu bar. 7 Paste Values to avoid errors when deleting columns. 5 Merging columns into one (CONCATENATE). 4 Splitting one column of text into two or more columns (Convert Text to Columns). 3 Autofill to copy a formula down a column. This document and other Information Services documents are held online on our website:Ģ University of Brighton Information Services Contents Find and Replace to update multiple entries in one hit. You can download the exercise files for this workbook from our website with the course code is141e. A basic knowledge of using functions in Excel like SUM and COUNT would be an advantage. This workbook assumes a working knowledge of Excel. Last updated 16 th July 2015 It is suitable for anyone who uses Excel on a Mac for databases such as lists of contacts, students or delegates. 1 Excel for Mac Text Functions HOW TO CLEAN UP TEXT IN A FLASH This document looks at some of the tools available in Excel 2008 and Excel 2011 for manipulating text.
0 kommentar(er)
