Concatenation...

S

Silas

Hi. I'm using the CONCATENATE function to combine text from two cells but I
need a space between the entries. I've tried hitting the space-bar and also
putting the space in quotes. Nothing works. I'm using Excel 97.

Thanks.

Silas
 
T

Trevor Shuttleworth

Silas

one way:

=CONCATENATE(B1," ",C1," ",D1)

or:

=B1 & " " & C1 & " " & D1

Regards

Trevor
 
Top