Hi everyone, i dont know much EXCEL code but im doing ok for now learning on the fly, i know VB so it makes it easier. so far i have been able to work everything out that i need to do kinda impressed with myself, but there in one this that is buggin my brain. I have a string below in cell A1 TLL-PROJ-PWAY-NONE-D13-000-oooo1 what i want to do is, slip the string so that A1 remains as it is, but the TLL will be in A2 (without the "-") the PROJ will go into A3 and so on. so far i have read a few books and googled a few pages to find =Left(a1,Find("-",a1)) but it doesnt quite do what i want it to any ideas please Thanks, bunty

The 'text to columns' feature is probably what you are looking for...Just use '-' as the delimiter. Good luck, -SN

Hi that doesnt seem to do what i want. u see i need it to do this dynamically because the values will be added to subsequent rows, for exaple if a1 through to a10 are ocupied, and i enter a new value in a11, i want b11, c11, d11 and so on to automatically slip the string and take their share of it. Please guys im trying over here but i cant seem to get the thing to work properly. Thanks, Bunty

well i gave up after the first two and gave it to my brother who dont it within 10 mins, well atleast i learnt something.. Cheers all :)