| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding position of last period in filename
I have a large spreadsheet of filenames. I'm trying to break the
names into Filename and File extension using LEFT and RIGHT functions. I'm having trouble getting some of these names because some of the filenames contain more than one period, eg., This.is.the.filename.DOC is in Col A. Can someone suggest a function that would separate both parts? This.is.the.filename in Col B DOC in Col C. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a position in a Cell using a formula | Excel Discussion (Misc queries) | |||
| Finding the position of the i-th non blank cell in a vertical range | Excel Worksheet Functions | |||
| Finding Column Position | Excel Discussion (Misc queries) | |||
| Period to Period percentage change? | Excel Discussion (Misc queries) | |||
| Finding number of particular days in a period | Excel Worksheet Functions | |||
Threaded Mode
