E
Evan
I create a monthly report recapping the number of hours each employee
logs against specific projects. The raw data for this report is
generated from the company's enterprise system. This includes the
employee name, which comes with a prefix code that I want to eliminate
in my report. Here's an example for an employee named "Tom J Smith".
The enterprise system lists him as "TJS - Smith".
All I want for my report is "Smith" so I use the following formula
where in this case "TJS - Smith" appears in cell F2:
=RIGHT(F2,LEN(F2)-FIND("-",F2,2)).
What I get is " Smith".
How do I structure the formula so I can eliminate the blank space in
front of the name?
logs against specific projects. The raw data for this report is
generated from the company's enterprise system. This includes the
employee name, which comes with a prefix code that I want to eliminate
in my report. Here's an example for an employee named "Tom J Smith".
The enterprise system lists him as "TJS - Smith".
All I want for my report is "Smith" so I use the following formula
where in this case "TJS - Smith" appears in cell F2:
=RIGHT(F2,LEN(F2)-FIND("-",F2,2)).
What I get is " Smith".
How do I structure the formula so I can eliminate the blank space in
front of the name?