to make split data in one column into two
e.g 41h 58m
then =SPLIT(G2," ") {G2 is cell number}
it will give
41h 58m
Further =SPLIT(Z2,"h")
Z2 is cell number
it will give
41 h
e.g 41h 58m
then =SPLIT(G2," ") {G2 is cell number}
it will give
41h 58m
Further =SPLIT(Z2,"h")
Z2 is cell number
it will give
41 h
No comments:
Post a Comment