View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
skmc skmc is offline
external usenet poster
 
Posts: 1
Default Find and Replace with wild cards

I have the following type of numbers/sqequence 1234-4567, which i want to
search for (????~-????), this works, but now i want to keep ONLY the 1st 4
numbers (i.e.) 1234 and discard the remaining (i.e.) -4567. Any help would be
appreciated!!