Followers

Wednesday, 20 March 2019

Excel Shortcuts - Split Forename and Surname


  • Finding the Middle name


Full Name
Middle Name
Alan David Jones
David
Bob John Smith
John
Carol Susan Williams
Susan
 =LEFT(RIGHT(C45,LEN(C45)-FIND(" ",C45,1)),FIND(" ",RIGHT(C45,LEN(C45)-FIND(" ",C45,1)),1))
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Workday and Networkday Day Excel Function

In this video, you will learn about two very important Excel functions: WORKDAY and NETWORKDAYS. These functions are incredibly useful for a...

  • Ms Excel - Sum Average and Averageif
     In Ms Excel you must heard about the function Sum ,Average and Averageif. Here i have created on video which will help you to understand th...
  • Leave encashment
      Today we will talked about Leave encashment In case employee have not taken leaves and have opted for encashing those leaves, employer wou...
  • Workday and Networkday Day Excel Function
    In this video, you will learn about two very important Excel functions: WORKDAY and NETWORKDAYS. These functions are incredibly useful for a...