Splitting text (string function using macro )

Dear All ,

Please attached file ,

Basically i want you to see Column C AND column D .

Basically Column C is folder path and Column D is folder name ..

The path will be there ,i want a macrp which seperates the text after the last \ and pastes it to the folder column ,

For example ,if it is

E:\Final Sourcecode Dhirendra\FINAL\play_cOMBIN -> in column C ,
in Column D it will be ->Play_COMBIN


Similarly if it is ,

E:\Final Sourcecode Dhirendra\FINAL\play_cOMBIN \wall -> in column C ,
in Column D it will be ->wall,

The loop will go through all entried in column C and will do the same operation ,

i want a macro to handle this ,please ,

Regards ,


Amlan Dutta

Dude ,that works like a charm,

See output file attached !!!!i have attached a button "Tiger " to your subroutine and it just swept me off!

i will mark the thread as solved and give you stars!

Thanks ,


Amlan Dutta

You are awesome to be so humble ,this forum is awesome ,first jaslake ,then stevens and now you ,i gues there are so many superb pros out here ,truly you guys rock!Yourl mean a lot to us !!!!Thanks a tonne