We want to use Excel to track printing in our office. I am able to get all
the info needed into a spreadsheet, but I have one 1 remaining glitch when I
need to sort the information. The project number column includes the full
path so there is no way to sort the log by project, but there is the same
number of characters before the project number.

Is there a way in Excel to create a macro or a function that our billing
person can easily apply to the cells in the column that says " delete the
first 14 characters in this cell" or "ignore the first 14 characters when
reading this cell"? I am not very familiar with macros, so any advice would
be appreciated.

Thank you and Happy New Year.