Excel Formula Shortcuts

Excel Formula Shortcuts

Total
0
Shares
  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.
You May Also Like
What is IaC

What is IaC?

Infrastructure as Code (IaC) provides a portable and reliable way to automate provisioning and maintain a desired state for your infrastructure. Written in human-readable languages like JSON or YAML, IaC…
View Post

YouTube services down

It is the first time ever we have encountered the service down error for YouTube. It is very unusual, as the service never goes down. This error indicates that YouTube…
View Post