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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 08:27 PM.