How To use PROPER ,UPPER & SPLIT Excel Function

            How To use PROPER ,UPPER & SPLIT Excel Function

• Excel is a popular spreadsheet software known for its number-crunching capabilities but also offers powerful tools for manipulating and formatting text data. Its two essential text functions, PROPER and UPPER, enable various transformations to improve readability and consistency in spreadsheets.

          PROPER Function

• The PROPER function is a tool that capitalizes the first letter of each word in a text string, while converting the rest to lowercase, making it useful for dealing with names, titles, or other text that requires consistent capitalization.

          How to Use PROPER

           =PROPER(text)

•  text  = The text requires correct capitalization.
•  Applying PROPER to a column with names in different formats standardizes capitalization,       enhancing the polishedness and professionalism of your data.

          UPPER function

• The UPPER function is a useful tool for converting all letters in a text string to uppercase, especially for headings or emphasizing specific points in a text.

         How to Use UPPER

         =UPPER(text)

• text = The text you wish to convert to uppercase.
• The UPPER function can be utilized to enhance the visibility of product codes in a column.

          SPLIT function

• The SPLIT function in Excel splits a text string into parts based on a specified delimiter, such as commas, spaces, or dashes, to separate data segments. It's ideal for situations where data is packed into a single cell and needs to be unraveled.

          How to Use SPLIT

           =SPLIT(text, delimiter)

• text = The text string that you wish to split.
• delimiter = The character that indicates the text's split point.
• SPLIT can be utilized to separate columns with names in the format "First Name, Last Name" into two.

          Example Watch this  Video