Re: Concatenate

Tom wrote:
> In this function, @CONCATENATE(D16+H47,"  ","Text"), I
can not get the two 
> cells I have added to format with a comma. Is there a way to do this.
> 
> Thanks,
> 
> Tom 

 From first look at what's above, it looks like you are trying to join 
(I can't spell concatenate) the results of D16+D17   with a couple of 
spaces and then with Text.  Maybe try putting a comma inside the first 
set of double quotes.

(Sorry, I don't have a working copy of QPro on this OS.  I have a .qpw 
file I tried to open with the OpenOffice spreadsheet last night but it 
didn't work.  It did have a Quattro Pro filter that I have yet to get to 
work.)

Tim

In this function, @CONCATENATE(D16+H47,"  ","Text"), I can
not get the two 
cells I have added to format with a comma. Is there a way to do this.

Thanks,

Tom 

Tom wrote:
> In this function, @CONCATENATE(D16+H47,"  ","Text"), I
can not get the two 
> cells I have added to format with a comma. Is there a way to do this.

  @CONCATENATE(@FIXED(D16+H47,0,0),"  ","Text")

Cheers,
Uli

Uil:

That worked great. Thanks for the answer so quickly.

Tom


> Tom wrote:
>> In this function, @CONCATENATE(D16+H47," 
","Text"), I can not get the 
>> two cells I have added to format with a comma. Is there a way to do
this.
>
>  @CONCATENATE(@FIXED(D16+H47,0,0),"  ","Text")
>
> Cheers,
> Uli
>