Hello all,
I've dataset like 17/Sep/2014:00:00:35
Then have to remove the symbol : only first one between date and time. Its mean the result have to be 17/Sep/2014 00:00:35
I tried many methods replace find etc.
Please help me,
Thank you.
Hello all,
I've dataset like 17/Sep/2014:00:00:35
Then have to remove the symbol : only first one between date and time. Its mean the result have to be 17/Sep/2014 00:00:35
I tried many methods replace find etc.
Please help me,
Thank you.
Assuming that you are having the data in A1 Place the function in B2
=LEFT(A1,FIND(":",A1)-1)&" "&RIGHT(A1,(LEN(A1)-(FIND(":",A1))))
Punnam
=SUBSTITUTE(A1,":"," ",1)
is more simple
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.
@ Special-k,
Thank you, i am not aware that this could be done so simple .(:-) .
Punnam
It works. Thank you PUnnam and Special-k
Last edited by Tse; 09-17-2014 at 06:04 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks