Thread: Please help. poss VBA
View Single Post
  #2   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
Assuming first name is in column A, second name is in column B, date of
birth is in column C and Gender is in column D (as M or F) then in
column E put the formula
=Left(A1,1)&"-"&Left(B1,1)&"-"&C1&"-"&D1

regards
Paul

Reply With QuoteReply With Quote