View Single Post
  #1   Report Post  
snooze
 
Posts: n/a
Default remove leading zeros from text strings

I have a long list of text strings and would like to remove leading zeros,
returning each string with zeros removed. Is there an easy way to do this
using excel text functions?

ie. 00234 234
02569 2569 etc