split cell content into two

[if_Excel]

i know you can manually use text to column to parse the content of a cell, but I ma looking for a formula the will split 2:58 into 2 in one cell and 58 in the another.

 

[yogeshmaney]

How abt LEFT and RIGHT Function

 

[tc88]

i know you can manually use text to column to parse the content of a cell, but I ma looking for a formula the will split 2:58 into 2 in one cell and 58 in the another.

Is it always going to be X:XX? Or could it be something like 11:35

If it's always one number before the column, I would use these functions, where A1 is where "2:58" is:

=LEFT(A1,1)

=right(a1,2)

 

[if_Excel]

left and right didnt work

 

[tc88]

left and right didnt work

Be a little more descriptive please? What output does it give you?

 

[yogeshmaney]

Try

=LEFT(TEXT(B2,"hh mm"),2)
=RIGHT(TEXT(B2,"hh mm"),2)

 

[if_Excel]

thanks to all. both version worked.