lianne143
asked on
How to replace : with / in excel column
Hi
I have a excel spread sheet and on Colum H the format is in
5:0
6:9
6:0
8:6
.
.
So on
I would like to replace : with \ is there a way to convert
5/0
6/9
6/0
8/6
Any help and tutorial would be great
Thanks
I have a excel spread sheet and on Colum H the format is in
5:0
6:9
6:0
8:6
.
.
So on
I would like to replace : with \ is there a way to convert
5/0
6/9
6/0
8/6
Any help and tutorial would be great
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please find the attached excel sheet and i have added the required colum from the actual spreadsheet.
I am not able to add / between the numbers. If replace / with : I get months.
Please help with step by step tutorials and how to sort this . I need to show my colleague as how i did.
Thanks
Book1.xlsx