Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

How to combine Time and Text in exc

Comment:

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?

Name: Mike (by mmcconaghy)
Date: March 29, 2009 at 13:28:28 Pacific

Reply:

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. MIKE

0

microsoft office 2000 sma...

How to delete similar wor...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: The first question we have to ask is: Are you are only talking about *one* piece of data in A1:A7 or do you need to combine all the data in A1:A7 and put it in A10? The next question would be is what ...

Summary: Hi Bryan, Well the ignorance is on my part totally. Did I fail to mention novice? :-) I do know how to download music and save it to my play list and burn my music to a CD using Windows Media Player 9...

Summary: Iam using MS outlook 2002. It is quite interesting. By Default it has the default settings of all e-mails in C:\Documents and settings\User_Name\Local Settings\Application Data\Microsoft\Outlook. I w...