Hi

I evaluate three formulas

A,B and C

on a group footer i want to display A - B - C in a textbox
but if one is null thne I want to not have a space

so A is blank then B-C
if B is blank then A-C  etc....

Thanks
Joe

Thanks for the info never used replace

It almost works..
It wants to leave a a space

I changed to replace({@A} + ' '+ {@B} + ' ' + C},' ',' ')

if A is not null
I get

A

if A is null and B is not

Then I get
 B

so the list looks like

A
 B
A B
 B

etc
Thanks

Thanks works great