Question: Type or paste question here please include formulas A B D E F G H I J 1 Last Ramey First Customer Name City State
Type or paste question here
please include formulas
A B D E F G H I J 1 Last Ramey First Customer Name City State alexandria va Status CURRENT 2 Liz 3 City State Status 4 Last 5 Ramey 6 First Liz 0 7 8 9 Enter a formula in cell C2 to combine the text from cells B2 and A2 to display the customer name in the format "Liz Ramey". Don't forget there is a space in between!!! 10 Enter a formula in cell 05 to display the text from cell D2 so that the first letter in each word is capitalized. 11 Enter a formula in cell E5 to display the text from cell E2 so all the letters display in UPPER case. 12 Enter a formula in cell F5 to display the text from cell F2 so all the letters display in lower case. 13 14 Check out: PROPER(), UPPER(), LOWER() 15 16 Enter a formula in cell C2 to combine the text from cells B2 and A2 to display the 18 customer name in the format "Liz Ramey". Don't forget there is a space in between!!! 17 19 20 21 Check out: CONCATENATE() 22
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
