View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shakey1181 shakey1181 is offline
external usenet poster
 
Posts: 27
Default Find Replace Formula

I'd like to replace the full stop from a cell with a '/' and have the result
in a second cell. So 01.01.06 would become 01/01/06.

I have to do this over multiple sheets and cells, so using the find replace
function would take too much time. If there a formula which would do this for
me automatically?

Thanks in advance