Microsoft Office Forums - View Single Post - extract time from a cell and move it to front of cell before text

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

View Single Post

Old

01-10-2017, 05:46 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

You can try this in B1 copied down...

=TRIM(MID(A1,FIND(" ",A1),5))&" "&TRIM(SUBSTITUTE(A1,TRIM(MID(A1,FIND(" ",A1),5)),""))

It works for your sample data, but could be something else to consider.

Reply With Quote