extract time from a cell and move it to front of cell before text

		Microsoft Office Forums > Microsoft Excel > Excel
extract time from a cell and move it to front of cell before text

FAQ

Thread Tools

Display Modes

#15

03-17-2017, 09:28 PM

ewso

Windows 10 extract time from a cell and move it to front of cell before text

Office 2016

Advanced Beginner

Join Date: Nov 2016

Posts: 80

Quote:

Originally Posted by xor

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?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Move the data at bottom cell to right side of the cell	kcyag91	Excel	1	01-28-2016 12:28 AM
I'm looking for a formula to extract all the text before the last name in a cell	Gef	Excel	4	02-01-2015 07:14 PM
How to extract text from a cell and preserve special formatting?	epid011	Word VBA	2	04-04-2014 04:54 PM
Add asterisks in front of all bold sentences in a table cell	mrayncrental	Word VBA	8	02-06-2014 11:48 PM
Move data from 1 cell to another cell	Catalin.B	Excel	1	06-25-2011 12:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:40 AM.