Quote: "After looking closer at ur code it makes sense and it seems you've used 2 commands i didnt know and both wouldve saved me alot of cos mid$() and left$()"
Well I hope you're making progress with things, especially as it's your homework (homework - jeez, been 17 years since I did that!!!)
But PLEASE take a tip from me, remember to make things simple, don't over complicate things.
The code I gave wasn't the final answer, but it a sure, simple, easy approach to the problem. Talk to yourself when trying to work something out - honestly, it does help...!
Best of luck with the coding, and remember to post your final answer, it'd be worth seeing just how you did it in the end.
~ J ~