I've attached a sample file, and I need the 3rd column to still leave the number in the box, but to automatically create a link based on a link template, and the 1st letter of the first name and the full lastname embedded in the link in a specific area.
The first row is how I want all of these to be, but I want this automated if at all possible, to where if we changed the name on column 2, it would update the name in the hyperlink next to it in column 3. Some sort of formula that would automatically fix these.
We would also need to be able to manually manipulate the link the the 3rd column without messing up column 2.
This would be a tremendous help to me.