I have a date, listed below and I want to add a space before it. When I used Concatenate, I get the result below. How and I simply add a space before the date and still see the date?
Date - 9:27:01 AM
Concatenate result - " "0.393761574074074
I have a date, listed below and I want to add a space before it. When I used Concatenate, I get the result below. How and I simply add a space before the date and still see the date?
Date - 9:27:01 AM
Concatenate result - " "0.393761574074074
In B2 paste:Please Login or Register to view this content.
Please Login or Register to view this content.
Assuming Date is in A1 and time in B1
Enter in C1
Formula:Please Login or Register to view this content.
Or if you want with the - separator
v A B C 1 4/18/2017 0.393761574 4/18/2017 09:27:01
Formula:Please Login or Register to view this content.
Last edited by AlKey; 04-18-2017 at 12:46 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks