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
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