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

Silas

one way:

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

or:

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

Regards

Trevor


"Silas" wrote in message
...
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

Hi
try
=A1 & " " & B1

--
Regards
Frank Kabel
Frankfurt, Germany


Silas wrote:
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

"Frank Kabel" wrote in message
...
Hi
try
=A1 & " " & B1

--
Regards
Frank Kabel
Frankfurt, Germany


Silas wrote:
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


I got it. Thank you.

Silas