Thread: Concatenation
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Concatenation

If you are using the ampersand:

=A1&" "&B1

The blank space goes in between quotes, I placed 2 spaces to make it more
obvious.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"jknapp1005" wrote:

I am trying to use the Concatenate function to join two columns of text. How
do I get a space between what I'm trying to concatenate?