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 EType 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!