Thread: Please help. poss VBA
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
  
Posts: 789
Default Please help. poss VBA
Hi
Try
=Left(A1,1)&"-"&Left(B1,1)&"-"&text(C1,"dd/mm/yy")&"-"&D1

regards
Paul

Reply With QuoteReply With Quote