CONCATENATE???

L

Larry

I have a series of cells containing info like this in cells A1 thru F1

6-1 8 PM text text text text

I need to combine this info into 1 cell say G1.

What is the formula for this?

Thanks!!!!
 
F

Frank Kabel

Hi
maybe something like
=A1 & B1 & C1 & D1 & E1 & F1

and if B1 is a time value try
=A1 & TEXT(B1,"hh:mm AM") & C1 & D1 & E1 & F1
 
D

Don Guillett

Have you looked in Help index for


CONCATENATE
See Also

Joins several text strings into one text string.

Syntax

CONCATENATE (text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a single text
item. The text items can be text strings, numbers, or single-cell
references.

Remarks

The "&" operator can be used instead of CONCATENATE to join text items.
 
D

Domenic

Hi,

try,

=CONCATENATE(TEXT(A1,"m-d")&" "&TEXT(B1,"h am/pm")&" "&C1&" "&D1&"
"&E1&" "&F1)

Hope this helps!
 
D

Domenic

Actually, I didn't need to put the CONCATENATE part of the formula. The
formula should have read:

=TEXT(A1,"m-d")&" "&TEXT(B1,"h am/pm")&" "&C1&" "&D1&" "&E1&" "&F1

that's assuming you want spaces between them.
 
B

Bob Phillips

To expand on Frank's reply, you might want some separators

=A1&" "&TEXT(B1,"hh:mm AM")&" "&C1&" "&D1&" "&E1&" "&F1

or some other character(s)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top