Combining Cells

[George Perrotta]

I have 4 cells that I need to combine into one cell. One cell has a
time in it. When I combine cells it does not come up as time but a
fraction.
A1 8:30
B1 A
C1 Cards
D1 Indians

My formula is =+A1&" "&+B1&" "&+C1&" "&+D1
I get this
0.354166666666667 A Cards Indians
I want
8:30 A Cards Indians

 

[Ron Rosenfeld]

I have 4 cells that I need to combine into one cell. One cell has a
time in it. When I combine cells it does not come up as time but a
fraction.
A1 8:30
B1 A
C1 Cards
D1 Indians

My formula is =+A1&" "&+B1&" "&+C1&" "&+D1
I get this
0.354166666666667 A Cards Indians
I want
8:30 A Cards Indians

1. The +'s are redundant, probably a holdover from Lotus123 programming and
not required in Excel.

2. =TEXT(A1,"h:mm") & " " & B1 & " " & C1 & " " & D1

Note that in order to obtain 8:30 (with no AM/PM), this is a variation of a 24
hr time format. So that if A1: 2:30 PM, your string will show 14:30.
--ron

 

[tompl]

Try this:

=TEXT(A1,"h:mm")&" "&+B1&" "&+C1&" "&+D1