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.

With a formula, you can just have another column that gives all remaining
number, if data is in B1
=RIGHT(B1,LEN(B1)-14)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"jwksu" wrote:

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.

Thanks John. That is perfect.

"John Bundy" wrote:

With a formula, you can just have another column that gives all remaining
number, if data is in B1
=RIGHT(B1,LEN(B1)-14)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"jwksu" wrote:

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.

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.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"jwksu" wrote in message
...
Thanks John. That is perfect.

"John Bundy" wrote:

With a formula, you can just have another column that gives all remaining
number, if data is in B1
=RIGHT(B1,LEN(B1)-14)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"jwksu" wrote:

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.