Scribd
Upload
280 views1 page

Essential Excel Data Entry Formulas

The document provides a list of formulas and their descriptions for various text and data manipulations in a spreadsheet. It includes functions for text formatting, data validation, lookups, and generating random numbers. Additionally, it mentions modern replacements for traditional functions like VLOOKUP.

Uploaded by

abhiabhishek9808i
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
280 views1 page

Essential Excel Data Entry Formulas

The document provides a list of formulas and their descriptions for various text and data manipulations in a spreadsheet. It includes functions for text formatting, data validation, lookups, and generating random numbers. Additionally, it mentions modern replacements for traditional functions like VLOOKUP.

Uploaded by

abhiabhishek9808i
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Formula Description

0 Converts text in A1 to uppercase.


0 Converts text to lowercase.
0 Capitalizes the first letter of each word.
0 Removes extra spaces from text.
0 Formats a date in a custom way.
0 Checks if the cell contains a number.
0 Checks if the cell contains text.
0 Flags missing entries.
0 Counts the number of characters.
74 Counts empty cells in a range.
0 Looks up data from a table.
0 Horizontal lookup.
0 Finds a value based on a match.
#NAME? Modern replacement for VLOOKUP.
0 Conditional result based on value.
0 Checks multiple conditions.
0 Prevents errors from blank or zero division.
0 Returns the row number.
0 Returns the column number.
45780 Inserts the current date.
45780.71 Inserts current date and time.
0.41056 Generates a random number between 0 and 1.
85 Generates a random whole number in a range.
0 Combines text and formatted number.
0 Joins multiple cells into one.

You might also like