Want to get text into meaning full components?
In today’s Excel Q&A, Philip Gamey shows how to use RIGHT, LEFT and MID functions to get an account code into meaningful components.
See the Youtube video on “Excel Q&A: Split Account Codes into Separate Columns” below:
monster indeed..... you have made my work easy. this was a problem i was facing in my office. thank you and i want more
bonti October 16, 2013