LectureManipulating TextChanging CaseCombining Cells w/ Static TextCombining Multiple Text CellsPortions of Text CellsCombining Text with NumbersAdditional Text/Data FunctionsLectureExcelWorking with Text and DataManipulating Text•Change upper/lower case•Combine cells with static text•Combine multiple text cells•Portion of text cells•Combine text with numbersChanging Case= UPPER(A2) BOB= LOWER(A3) cathi= PROPER(A4) DavidCombining Cells w/ Static Text= “Hello ” & A2 Hello Bob= “Mr. ” & B3 Mr. Carlson= “Hello, ” & A4 & “!” Hello, David!Combining Multiple Text Cells= A2 & “ ” & B2 Bob Baker= B3 & “, ” & A3 Carlson, Cathi= “Mr. ” & A4 & “ ” & B4Mr. David DentPortions of Text Cells= LEFT(A2,1) & “. ” & B2B. Baker= RIGHT(B5,4)nsen= MID(B8,3,4)arbeUseful when combined with other functions like FIND.Combining Text with Numbers= A2 & “: ” & B2 Bob: 77= A3 & “scored ” & B3 Cathi scored 96= IF(B5>90,“Great job, ”&A5,“Bummer.”)Great job, Jake= IF(B8>90,“Great job, ”&A8,“Bummer.”)Bummer.Additional Text/Data Functions•Spell Check•Filter–Data | Filter | AutoFilter•Find/Replace•Sort–Data | Sort•(Expand Selection if prompted)•Paste
View Full Document