"change 04/02/07 to 040207"
wrote in message ...
merge three cells

Depending what the cells contain, you could use Concatenate....