Thread: extract time from a cell and move it to front of cell before text
View Single Post
 
Old 01-10-2017, 08:10 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Maybe you can use the following absolutely awful array formula:

=TEXT(LOOKUP(9^9,1*MID(A1,MIN(IF(ISNUMBER(1*MID(A1 ,COLUMN(1:1),1)),COLUMN(1:1))),COLUMN(1:1))),"hh:m m")&" "&MID(A1,1,MIN(IF(ISNUMBER(1*MID(A1,COLUMN(1:1),1) ),COLUMN(1:1)))-1)&MID(A1,FIND(" ",A1,MIN(IF(ISNUMBER(1*MID(A1,COLUMN(1:1),1)),COLU MN(1:1))))+1,LEN(A1))
Reply With Quote