I need to create a Spreadsheet where a certain Value is added to the from of the data I enter into the cell.
For example:
All of my MAC Addresses start with 00:80:64.
I want to be able to just type in the last three entries into the cell and have Excell automatically add the value 00:80:64
So I want to be able to add a specified value to ebvery entry in a collumn.
Any Ideas on how to do this?
THank you