Splitting text (string function using macro )

[amlan009]

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