Microsoft Excel functions question

sphott

 How do I combine all those functions together?  


In cell D3, use the RIGHT, LEN, and FIND functions to extract the first name from column C. Use the PROPER function to ensure that all first names are in the appropriate case.

So far I've done =RIGHT([@[Clean Name]],LEN([@[Clean Name]]-FIND(" ",[@[Clean Name]]

    • 6 years ago
    • 10
    Answer(0)
    other Questions(10)