If extension of a path in a cell is .pdf then

Posted to microsoft.public.excel.programming

Mark[_66_] Mark[_66_] is offline

external usenet poster

Posts: 24

If extension of a path in a cell is .pdf then

Hello

Was wondering how to go about this. I have a bunch of file paths all
in column E. I wanted to generate either "External" or "Internal"
into column F depending on whether the file extension is .pdf
or .html.

Any ideas?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert file name in cell without .xls extension	Steve	Excel Discussion (Misc queries)	8	April 3rd 23 04:25 PM
Remove end folder from path found with ThisWorkbook.Path command ?	dim	Excel Programming	9	April 23rd 08 06:04 AM
hyperlink navigation path path wrong in Excel 2003	CE Admin	Excel Discussion (Misc queries)	5	January 7th 06 07:47 PM
cell character extension	R Smith	Excel Worksheet Functions	3	June 15th 05 08:10 AM
Transformation d'images avec une extension .jpg ou .jpeg en images avec extension .bmp ou .ico	imej-clavier	Excel Discussion (Misc queries)	1	May 28th 05 05:52 PM

All times are GMT +1. The time now is 05:21 PM.

Menu

About Us