View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Snowsride Snowsride is offline
external usenet poster
 
Posts: 20
Default Find first non numeric character in string

I want to strip out the first part of a string so that the result starts with
the first non numeric character. The second numeric value (19184 in the
example below) is an id that can vary in length so I can't just use the mid
function as the starting point will vary.

Example:

"1 - 19184 - BP Trowbridge Lodge Service Station"

I want to return "BP Trowbridge Lodge Service Station"

Thanks for any help