Prev: Duplicates formula
Next: visible cell only
From: George Perrotta on 12 Apr 2010 13:12
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



From: Ron Rosenfeld on 12 Apr 2010 13:49
On Mon, 12 Apr 2010 10:12:56 -0700 (PDT), George Perrotta
<perrotta48(a)gmail.com> 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
From: tompl on 12 Apr 2010 14:10
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
>
>
>
> .
>
 | 
Pages: 1
Prev: Duplicates formula
Next: visible cell only