Differences

This shows you the differences between two versions of the page.

--- toolsandtechnologies:useful_excel_formulas [2017/05/12 12:19] – mmcc
+++ toolsandtechnologies:useful_excel_formulas [2021/06/25 10:09] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== Useful Excel Formulas ======
+Author: Michelle McCausland
+===== Cell Referencing =====
+{{ :toolsandtechnologies:image.png?nolink |}}
+----
+===== =RIGHT() =LEFT() =====
+<code> =RIGHT(A1,9) &", " </code>
+Using the contents of cell A1, this formula removes 9 characters from the right and prints with , at end (same for =LEFT())
+<code>=RIGHT(A1, LEN(A1)-1)</code>
+Try this out on a cell of text to see the effect.
+----
+===== =CONCATENATE() =====
+<code>=CONCATENATE(A1,", ",B1)</code>
+This formula concatenates / appends the contents of multiple cells into 1 cell.
+----
+===== =VLOOKUP() =====
+The VLOOKUP function lets you search for specific information in your spreadsheet. For example, if you have a list of network elements with ids, you could search for the id of a specific network element.
+This formula can prove very useful when comparing 2 sheets of data to see what is missing.
+[[https://www.gcflearnfree.org/excel-tips/how-to-use-excels-vlookup-function/1/|VLOOKUP Walkthrough]]

Internal Errigal Collaboration Wiki