View Single Post
  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Create filename from three cells and get to clippboard

Try this

=A1&" "&TEXT(B1,"mmddyy")&" "&TEXT(C1,"mmddyy")

change date format accordingly

--
Regards,

Peo Sjoblom

(No private emails please)


"Booker" wrote in message
...
Thanks for reply.

It looks helpfull but isnt, in cell B1 and C1 is date.

Result is "DA016-0O 38668 38668"