Thread: extract time from a cell and move it to front of cell before text
View Single Post
 
Old 01-10-2017, 02:36 PM
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
As I wrote, it is an array formula which means that when completing the formula you must hold down Ctrl and Shift before pressing Enter instead of just pressing Enter. If you do it correctly Excel will automatically put braces {} around the formula. Do not try to enter these braces manually.
Reply With Quote