Spacing

[Former Member]

Hi,

I have a formula that has 3 different formulas

Ex:

Name    Address     Age

I want these formulas to be space evenly. If my first row data has a name with 5 characters then my address should start at position 7 but if my second row name has only 4 characters in the name then I still want my address to start at position 7 and not at 6.

Is there a way to do this.

Appreciate any help

Thanks

[nscheaffer]

All you need to do is pad the Name on the right using the Space function and then take the left most 7 characters.  Something like this...

Left(Trim({Name}) + Space(7), 7) + {Address} + " " + {Age}

This will only work if name is 7 characters or less.  The Trim is in there to get rid of any undetermined number of trailing spaces that may be there.  You could do the same sort of thing with the address if necessary.

Noel