How to combine Time and Text in exc

March 29, 2009 at 12:31:07
Specs: Windows XP
I am trying to combine Time from 1 cell and text from another but all I get is the long decimal number every time. This is what I have:

B2 1:05 PM
C2 White Sox at Diamondbacks

I want it to say
1:05 PM White Sox

how can I do this?

See More: How to combine Time and Text in exc

Report •

March 29, 2009 at 13:28:28
This will give you what you want:

=TEXT(B2,"h:mm AM/PM")&" "&LEFT(C2,9)

BUT, it is rather specific to your example.
You also asked how to remove the "at Diamondbacks" in another message.

With more information we might be able to help more.


Report •
Related Solutions

Ask Question