View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default How to trim cell information

On Mon, 22 Oct 2007 23:00:59 -0400, Ron Rosenfeld
wrote:

The problem is that without some rule (3 or 4 characters) or an all-inclusive
list, you really can't tell whether the characters after the last dot are a
file type extension, or part of the file name.


For clarity, I should have added to that sentence:

"...or part of the file name, if you make the file type extension optional"
--ron