none
Excel Formula for get first letter from each word and whole text of last word from full name RRS feed

  • Question

  • Dear All,

    I want get first letter from each word and whole text of last word from full name. For Examples;

    Full name is Sampath Kauminda Kaluarachchi. I want to take it as S.K. Kaluarachchi

    Another example is Sonali Lakshika Hasini Dikkubura. I want to take it as S.L.H. Dikkubura

    Like that I want to convert name. Please help me to do this one.

    Thank You

    Saturday, August 26, 2017 6:00 AM

All replies