Snippet TrainingLearn only what you need when you need it, from the comfort of your own desk
By protecting a worksheet, you can prevent unauthorized users from modifying it. You can protect an entire worksheet or protect only a part of it, permitting users to alter the other parts. You can also protect workbooks by using passwords and digital signatures.
This function allows you to join data found within several different cells into one cell. For example, if the first and last name of an employee is found in two different cells, this function can join the names into one cell.