View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Remove characters from string

On Sun, 28 Jan 2007 07:37:29 GMT, Ken McLennan
wrote:

However, if there were a number preceding the time that was not a time, it
would have to be modified.


I can do a bit of 'pre-cleaning' to, hopefully, alleviate such a
thing.


If you can present the variability in the original data, it may be easy to
modify the regex "Pattern"


--ron