Thread: extract time from a cell and move it to front of cell before text
View Single Post
 
Old 03-17-2017, 09:28 PM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
  
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
Just change all A1 to C1 and copy down.
xor, i tried that, but it doesn't work. i pasted the formula into the 'd' column and tried to manipulate the data into the 'c' column, but all i get is #n/a in the 'd' column after running the formula. is there something else that needs to be changed?
Reply With Quote