# Thread: Combining cells - both not text (Excel 97 SR2)

1. ## Combining cells - both not text (Excel 97 SR2)

Is it possible to combine two cells in Excel 97 where both are not formatted for text. Example: I would like to combine 1 cell that has a time reference (1:05) and another cell that has the part of day (AM or PM) so that I get "1:05 PM" in one cell. When I use the command with the "&" sign, it converts the time (1:05) to a text format. Reformatting the new combined cell to "time" does not work. Thank you for your help. Also, if it can be done, would it work the same way in XP? I also have access to that, but not as my primary system.

2. ## Re: Combining cells - both not text (Excel 97 SR2)

I think you can achieve what you want just by formatting the cell with the time value. If you use h:mm AM/PM as the format, 13:05 would display as 1:05 PM. Using 1.05 as a value means 1:05AM.

Once you concatenate two values, they become a Text value and cannot be used in numeric calculations.

Andrew C

3. ## Re: Combining cells - both not text (Excel 97 SR2)

If the time is in A1, and the AM/PM is in B1, then use this formula:

<pre>=TIMEVALUE(TEXT(A1,"hh:mm")&" "&B1)
</pre>

You will have to format the cell to time format.

4. ## Re: Combining cells - both not text (Excel 97 SR2)

1.05 = 1:12 AM not 1:05 AM

Steve

5. ## Re: Combining cells - both not text (Excel 97 SR2)

The message said 1:05 not 1.05.

6. ## Re: Combining cells - both not text (Excel 97 SR2)

Andrew stated (he has a decimal NOT a colon)
<hr>Using 1.05 as a value means 1:05AM. <hr>

Hence my correction (1:05 as a value would equal 1:05 AM, but 1.05 as a value = 1:12 AM)
Steve

7. ## Re: Combining cells - both not text (Excel 97 SR2)

Steve

Thank you for spotting this, but the error on my part was more typographical than mathematical.

Andrew

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•