Dears,
I need your help. I have 5 columns, each with some data. On the 6th column I need to combine the data from all 5 columns into column 6 to be as:
Data in A2-Data in B2-Data in C2-Data in D2-Data in E2
With one exception. column D is the date in this format 27-Aug-09
I need the date to be modified on the fly from 27-Aug-09 to be 270809 which will be the info in D2
See example attached. Can you help please. Thanks
Sam
Bookmarks