View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Guest3731 Guest3731 is offline
external usenet poster
 
Posts: 4
Default copy & replace questions

Hi - closely-related find & replace questions for Excel (or Word if
necessary??):

1. Can I remove white space from the beginning of (a range of) cells?
2. Is there a "replace" wildcard that matches "the first captured
regular expression," as in Perl? That is, can Excel find
<whitespace<number and replace it with <number - that is, replacing
<number with *itself*, rather than with anything else?

Thanks *very* much -