Hello,
if in cell there are dates and Status, I want to separate the dates as per the satus
current
in a single cell 12/14/2010 Set to Drtaft by Sameer M, 12/15/2010 set to open by Ganesh H, 12/16/2010 Set to open by Nikhil M, 09/10/2010 set to Pending sing off by Adwait M etc.....
I want it like
column A B C D
set to Draft Set to open Set to Pending sign off
12/14/2010 12/15/2010,12/16/2010 09/10/2010
ect.......
Please help me........!
if in cell there are dates and Status, I want to separate the dates as per the satus
current
in a single cell 12/14/2010 Set to Drtaft by Sameer M, 12/15/2010 set to open by Ganesh H, 12/16/2010 Set to open by Nikhil M, 09/10/2010 set to Pending sing off by Adwait M etc.....
I want it like
column A B C D
set to Draft Set to open Set to Pending sign off
12/14/2010 12/15/2010,12/16/2010 09/10/2010
ect.......
Please help me........!