COMBINE FORMULA IN EXCEL
INTRODUCTION
In MS-Excel, we can combine different types of functions to get the desired result.
Find Valid Contact Numbers
The below excel formula can be used to find the value contact numbers from given mobile numbers.
=IF(LEN(A2)=10,"Valid","Invaild")
Explanation: In the above formula, we inserted the "Len" function inside the "If" function to find the valid and invalid contact numbers.
If the total length of contact number is equal to 10 digits, then the "Valid" message will print, otherwise, the "Invalid" message will print.
Fetch First Name From Complete Name
The below excel formula using to fetch only first name from a complete name.
=LEFT(A2,FIND(" ",A2))
Explanation: In the above formula we are inserting "Find" function in "Left" function to extract only first name. Actually, we are extracting text until the blank space from the left side by "Left" function.
Formula To Remove Mr. and Miss From Name
=RIGHT(A3,LEN(A3)-FIND(" ",A3))
Explanation: In the above formula we are removing Mr. and Miss by combining three functions Right, Len and Find.
Apply Two Functions Simultaneously
=PROPER(TRIM(A2))
Explanation: In Excel, we can apply two or more than two functions simultaneously in one cell, just like above example.
Formula To Remove Mr. and Miss From Name
=RIGHT(A3,LEN(A3)-FIND(" ",A3))
Explanation: In the above formula we are removing Mr. and Miss by combining three functions Right, Len and Find.
Apply Two Functions Simultaneously
=PROPER(TRIM(A2))
Explanation: In Excel, we can apply two or more than two functions simultaneously in one cell, just like above example.
0 Comments