If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining Cells
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 |
#2
|
|||
|
|||
Combining Cells
On Mon, 12 Apr 2010 10:12:56 -0700 (PDT), George Perrotta
wrote: 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 |
#3
|
|||
|
|||
Combining Cells
Try this:
=TEXT(A1,"h:mm")&" "&+B1&" "&+C1&" "&+D1 "George Perrotta" wrote: 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 . |
Thread Tools | |
Display Modes | |
|
|