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.
