Let's say you've run a report and downloaded it to Excel. Let's also say that this report doesn't have a need by date field, but the need date is part of a reference code that looks like this:
110308/20/7R13504
Let's also say that you want to do a pivot table where all your records are summarized by need by date and you are OK with the format mmddyy (for now).
Here's what you do:
=left(a2,6)
This formula will return this result:
110308
The RIGHT function works the same way:
=right(a2,7)
Will return this result:
7R13504
These are definitely nice functions to have in your toolbox. And, there is more. I'll look at MID tomorrow.
Oh, and if you're in the US and you're on the left or on the right, I don't care. VOTE TODAY!
No comments:
Post a Comment