Separate strings of ascending order of 4 and 5 digits
Separate strings of ascending order of 4 and 5 digits
Enter in cell T5 and copy across
For 4 digits
Formula:=--MID($I5&$J5&$K5&$L5&$M5&$N5&$O5&$P5&$Q5&0,COLUMNS($T:T),4)
Change 4 to 5 for 5 digits
Last edited by AlKey; 05-14-2017 at 09:45 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
hello, ALKEY PERFECT , THANK YOU!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks