Hi,
Can you please help me with a very nagging issue,
I am trying to merge the following together into a new cell:
A1 = 12:00
B1 = AM
I need a formula to place into C1, that will present the following "12:00 AM"
I have already tried = A1&" "&B1 (however this did not work)
Thanks,
Longie1985
May be this.........
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Fantastic!! thanks for resolving
Try
=TEXT(A1,"hh:mm")&" "&B1
Life's a spreadsheet, Excel!
Say thanks, Click *
Glad to help you. Thanks for the feedback and rep.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
@Ace_XL
That's really cool. I didn't think in that angle.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks