How to trim the white space in crystal report?

Hello,

I have several column in my page header around 7-8 columns....However, depending upon some conditions my columns may be suppressed...when my column are suppressed blank space is seen.

Example... i have column
Member No ---- Name---- Address --- State

Now suppose depeding upon a condition my Address field is suppressed then while viewing the report i get to see
Member No ----- Name ---- ----State

So, i need solution which will trim the space after Name column and i get to see output as

Member No ---- Name ----State

Please help me.....

Thanks!

Best Regards,
Rohan Laghate