Excel will tell you how many replacements it has made. This tells Excel you want to replace the word Life with the word Super. This asks Excel to find all instances of the word Life. Select the column containing the membership types by clicking on the column header for column F. We want to therefore replace any instances of the word Life with the word Super.

We have renamed our Life membership to now be called Super. For this exercise, imagine that we have changed the branding of our membership types. Exercise A Using Find and Replace Open up the exercise file Find_Replace.xlsx. Click on Replace Type the text that you want to replace in the Find what box Type the text that you want to replace it with in the Replace with box. 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.

Excel 2008 for mac will not open