View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rev Les Hall Rev Les Hall is offline
external usenet poster
 
Posts: 1
Default Mass Changes in Excel using Wild Cards or other

Help - I've a large spread sheet that needs updating & I'd rather do it in
auto than have someone re-type each cell.

Is it possible to mass replace 4 Characters in a cell with the same 4
characters followed by another charcter or a space?

For example Replace BD22 with BD22X. I've tried the Wild Card ?? which
partially works in that by using BD?? it will find and replace BD?? with
BD??X but unfortunatelly the original charcters are then replaced by the ??

Thanks in anticipation