Microsoft Excel Spreadsheet Tips


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

Share