Wednesday, 29 January 2020

SPLIT

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

No comments:

Post a Comment