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

03-19-2017, 11:32 AM

xor

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

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

Select C1

3, press Ctrl+X (to Cut), select the upper left corner where you want to paste it to and press Ctrl+V. You can also, if you want, just Cut and Paste the formulas, that is select D1

3; press Ctrl+X (to Cut), select the upper left corner where you want to paste it to and press Ctrl+V.

Please note that Ctrl+X means a two key operation, Ctrl and X. The plus sign should not be entered.

« 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 01:51 AM.