Padding a string with spaces

[Mark Hardman]

(03-02-2015 07:20 AM)Joe Horn Wrote:  Here's an unexpected hidden feature. To pad a short string with spaces so that its total length is X characters, all it takes is:

REPLACE(string,X+1,"")

It looks like this can be used to generate a left padded string by swapping the arguments:

REPLACE("",X+1,string)

For example:

Code:


REPLACE("",10+1,"ABCDE") --> "          ABCDE"

ETD: This doesn't work as well as first though (see below).