Times will not conanceate .

Hello all ,

I want to simply conanceate col AL and AM but its not working . As per results in col L .

I intend to run up to nine of these then work on splitting data to individual cols later .

I had built four of these macros just simply conanceating back and forth between my conan cols L and BE .

The fifth macro turned my time into a huge decimal point number . Grrrrrwwww .

There can not be blank cells when I conanceate as you know this would not align later when spltting
data using text to columns . Hence the letter T to fill cells with no time .

Results in cells L3 , L4 , L5 should look the same as in my 3 examples in col BJ .

Hope this is an easy fix . Again I played around with format but no joy .

Thanks .

Hi,

Change column L from "Text" to "General" formatting--

Use formula

Please Login or Register  to view this content.

Sorry im missing the point here , where does your function go , into which col please .

Thanks guys , i have everything working properly now .
Thanks again .