Operations in Excel
Excel
Excel: How to Extract Last Name from Full Name
You can use the following formula in Excel to extract the last name from a full name in a cell:
=RIGHT(A2,LEN(A2)-FIND("*",SUBSTITUTE(A2," ","*",LEN(A2)-LEN(SUBSTITUTE(A2," ","")))))
This particular formula...
Excel
Excel: How to Extract First Name from Full Name
You can use the following formulas in Excel to extract the first name from a full name in a cell:
Method 1: Extract First Name...
Excel
Excel: How to Use COUNTA with Criteria
You can use the COUNTA function in Excel to count the number of cells in a range that are not empty.
However, sometimes may want...
Excel
Excel: How to Convert Time Duration to Minutes
You can use the following formula to convert a time duration to minutes in Excel:
=VALUE(B2*24*60)
This particular formula converts the time duration in cell B2...
Excel
Excel: How to Convert Time Duration to Seconds
You can use the following formula to convert a time duration to seconds in Excel:
=VALUE(B2*24*3600)
This particular formula converts the time duration in cell B2...
Excel
How to Calculate Median of Filtered Rows in Excel
You can use the following syntax to calculate the median value of a filtered range in Excel:
=AGGREGATE(12,1,B2:B13)
The value 12 is a shortcut for calculating...
Excel
Excel: Apply Conditional Formatting Based on Date
To apply conditional formatting to cells in Excel based on date values, you can use the New Rule option under the Conditional Formatting dropdown...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read