Skip to content
Home Excel Formula Shortcuts

Excel Formula Shortcuts

    Last updated on October 18th, 2022 at 08:12 am

    1. Save: Alt + Shift + F2
    2. Length of cell: =LEN(B5)
    3. Sum of cells: =SUM(C8:C11)
    4. Add character, beginning or end of text: =”(“& A2 &”)”

    5. Add character in middle of text: =LEFT(A47,1) & “-” & MID(A47,2,100)

    • LEFT(A47,1) = “1” means that the new text, in our example “-“, will be added after the first character.
    • MID(A47,2,100) = “2” represents from what position in the text, to add the rest of characters. “100” means the limit of characters to add.
    Fernando

    Fernando

    Just a hobby to write about interesting topics in our daily lives. Always looking for improvements and better ways of doing things...🚀