Link to home
Start Free TrialLog in
Avatar of lianne143
lianne143Flag for United States of America

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
SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lianne143

ASKER

Hi

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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial