Basic Text functions are a useful way to edit databases.
PROPER function
Capitalizes the first letter of every word in the cell.
=PROPER(text)
UPPER function
Capitalizes every letter in the cell.
=UPPER(text)
LOWER function
Formats each letter in a cell as lowercase.
=LOWER(text)
TRIM function
Removes excess spaces from the contents of a cell.
=TRIM(text)
Master Microsoft Office
Office helps users create professional reports, presentations, records, and more. Excel, along with other apps such as PowerPoint, is an essential tool for anyone working in a business setting.
We offer the best Microsoft Office training in NYC. Our expert instructors guide students of all levels through step-by-step projects with real-world applications. Sign up individually, or contact us about corporate training today: