splitting of cells

shankar

New Member
Joined
Oct 26, 2005
Messages
41
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
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Banker1

Active Member
Joined
Mar 10, 2005
Messages
463
Perhaps you could provide an example so that we can better help you.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,909
Messages
5,574,986
Members
412,630
Latest member
Eireangel
Top