Formatting Cells

[jwksu]

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.

 

[John Bundy]

With a formula, you can just have another column that gives all remaining
number, if data is in B1
=RIGHT(B1,LEN(B1)-14)

 

[jwksu]

Thanks John. That is perfect.

With a formula, you can just have another column that gives all remaining
number, if data is in B1
=RIGHT(B1,LEN(B1)-14)

 

[RagDyeR]

You have answers to your post in the misc. group.

Please don't multi-post.

It wastes the efforts of multiple responders who might duplicate answers
already received.

If this were cross-posted, at least then all the responses could be seen by
all.