Internal Errigal Collaboration Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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]]

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools