iF I have an excel cell VALUE OF:
2014-07-07T12:01:58;2014-07-07T14:01:58
I want to extract the dates from this cell and put the value on 2 separate cells.
A1: 2014-07-07 12:01:58
B1: 2014-07-07 14:01:58
Appreciate your help....Thanks
iF I have an excel cell VALUE OF:
2014-07-07T12:01:58;2014-07-07T14:01:58
I want to extract the dates from this cell and put the value on 2 separate cells.
A1: 2014-07-07 12:01:58
B1: 2014-07-07 14:01:58
Appreciate your help....Thanks
Two Helper columns perhaps?
=SUBSTITUTE(LEFT(A1,19),"T"," ")+0
and
=SUBSTITUTE(RIGHT(A1,19),"T"," ")+0
Otherwise a VBA approach
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks a lot...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks