splitting of cells

[shankar]

Hi

i want to split the continuous lines in to columns but i need only the last colunmn of a row

lets say i have a file in one directory.

"C:\Documents and Settings\qnfrgs\My Documents\Person\amort.xls"

i want to paste the above path in my sheet.(which will be automatically paste in single cell).
i want only the last name i.e., 'amort.xls' in my cell.

how to paste only the last name of the file.

shan

 

[Banker1]

Perhaps you could provide an example so that we can better help you.