Scribd Logo
Upload

Welcome to Scribd!

  • 17 views

    Spreadsheet Text Functions

    Uploaded by

    Srijana Shet
    This document describes various text functions in Excel including LEFT, RIGHT, MID, LEN, FIND, PROPER, REPT, TRIM, UPPER, LOWER, SUBSTITUTE, CONCATENATE, JOIN STRINGS, YEAR that can be used to manipulate strings and extract portions of text. It also provides examples of problems that can be solved using these string functions, such as creating an email address from parts in different cells and using string functions to derive new columns from data in an imported CSV file.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Spreadsheet Text Functions

    Uploaded by

    Srijana Shet
    17 views18 pages
    This document describes various text functions in Excel including LEFT, RIGHT, MID, LEN, FIND, PROPER, REPT, TRIM, UPPER, LOWER, SUBSTITUTE, CONCATENATE, JOIN STRINGS, YEAR that can be used to manipulate strings and extract portions of text. It also provides examples of problems that can be solved using these string functions, such as creating an email address from parts in different cells and using string functions to derive new columns from data in an imported CSV file.

    Original Title

    spreadsheettextfunctions-190926085520

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document describes various text functions in Excel including LEFT, RIGHT, MID, LEN, FIND, PROPER, REPT, TRIM, UPPER, LOWER, SUBSTITUTE, CONCATENATE, JOIN STRINGS, YEAR that can be used to manipulate strings and extract portions of text. It also provides examples of problems that can be solved using these string functions, such as creating an email address from parts in different cells and using string functions to derive new columns from data in an imported CSV file.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    17 views18 pages

    Spreadsheet Text Functions

    Uploaded by

    Srijana Shet
    This document describes various text functions in Excel including LEFT, RIGHT, MID, LEN, FIND, PROPER, REPT, TRIM, UPPER, LOWER, SUBSTITUTE, CONCATENATE, JOIN STRINGS, YEAR that can be used to manipulate strings and extract portions of text. It also provides examples of problems that can be solved using these string functions, such as creating an email address from parts in different cells and using string functions to derive new columns from data in an imported CSV file.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 18

    Spreadsheet

    TEXT
    FUNCTIONS
    LEFT
    ()
    You can use the Left function when you want to extract the leftmost characters from a
    string. Syntax =left(text, num_char)
    RIGHT
    ()
    Similarly, you can also use the Right function to extract the rightmost characters from
    a string. Syntax =right(text, num_char)
    MID
    ()
    Mid function in Excel is used to extract the characters from the middle of a string. Syntax
    = MID(text, start_char, num_chars)
    LEN
    ()
    Len function in Excel helps you to know the length of a string that is number of characters
    in a string. Syntax = LEN(text)

    Note – Spaces are included while calculating length.


    FIND
    ()
    Find function in Excel is used when you want to know the position of certain characters
    in a particular string. Syntax =FIND(find_text, within_text,[start_num])
    PROPER
    ()
    Proper function in Excel capitalizes each word in the string that is, it converts the case
    into proper case. Syntax =PROPER(Text)
    REPT
    ()
    Rept function in Excel is used when you want a certain text to be repeated certain number
    of times. Syntax =REPT(Text, number_times)
    TRIM
    ()
    Trim function in Excel removes the unnecessary spaces from a particular
    string.

    Syntax =TRIM(Text )
    UPPER
    ()
    Upper function in Excel converts the text into Upper case from lower case.
    Syntax
    =UPPER(Text )
    LOWER
    ()
    Lower function in Excel converts the text into Lower case from upper case.
    Syntax
    =LOWER(Text )
    SUBSTITUTE
    ()
    Substitute function in Excel helps to replace existing text with a new text in a
    particular string. Syntax =SUBSTITUTE(text, old_text, new_text, instance
    number)
    CONCATENATE
    ()
    Concatenate function in Excel helps to join the text of two or more cells.
    Syntax
    =CONCATENATE(text1, text2….)
    JOIN STRINGS
    ()
    To join strings, use the &
    operator.
    JOIN STRINGS
    ()
    To join strings, use the & operator and within “ ” can include any
    text/string.
    YEAR
    ()
    Extract the year out from the entire
    date
    Problem -
    1
    Use String/Text Functions to create the email address in
    E2
    Problem -
    2
    1. Import the file example_problem2.csv in Spreadsheet (download from
    Google Classroom)
    2. Use string functions to create the columns in blue.

    You might also like