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-18-2017, 12:41 AM

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

You did remember to enter as array formula (as I wrote in #10)?

yes, i remembered to hit shift+control+enter. when i test the file you attached, this is how the data looks after running the formula:

tt:01 john bob harry doe don
tt:01 jane jill sam

tt:01 lara tim jim

what could be wrong with it?

« 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 03:24 PM.