View Single Post
  #1   Report Post  
Night Owl
 
Posts: n/a
Default Removing numbers from the beginning of a text string

I have a long list of addresses, some of which start with a house number
then a comma. Is there a (simple) way of finding the position of the comma
within the first (say) 5 characters of the string, and, if it exists, remove
everything to the left of and including the comma, leaving the rest of the
text string?

Thanks in advance,

Pete