Excel Tips
How to Add Characters to the Beginning of a Cell Entry:
=”#”&A1
*A1 is the cell location
* Adding a # symbol in front of the cell entry
________________________________________
How to Add Characters to the End of a Cell Entry:
=A1&”-LTX”
*A1 is the cell location
*Adding -LTX to the end of the entry
______________________
Copy the last X # of Digits from a Cell:
=RIGHT(A1,4)
* A1 is the cell, 4 is the # of last characters to copy.
________________________
To copy a formula across all cells in a column
* double click the bottom right corner of the cell