Hi there, I want to find a way of getting times in minutes into split columns.
See example below text string in cell O2
3 30 38 73 90
Times will either be single or double digit (ie no higher than 99).
Assuming the above times are in Cell O2 - how can I populate P2 = 3, Q2=30, R2=38, S2=73, T2=90, U2= "", V2="" etc
using a formula
Use this:
=TRIM(MID(SUBSTITUTE(" "&$O2," ",REPT(" ",125)),125*COLUMNS($A:A),125))
It wll return TEXT, and thus keep leading zeros. Ig you need NUMBERS...
=--TRIM(MID(SUBSTITUTE(" "&$O2," ",REPT(" ",125)),125*COLUMNS($A:A),125))
and leading zeros will be lost.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Legend, thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks