INSERT trailing spaces

[GMAGDNA]

Is there a Customer Number Type that will insert a specified number of trailing spaces (null characters)? Kinfd of like the Custome Number Type 00000 will insert leading zeroes for the balance of a 3 digit number.

In other words, I will type in 12345 and have it format to:
12345 <null><null><null>

or type in 123456 and have it format to:
123456<null><null>

[shg]

You could use formatting for a 1-. 2-, or 3-space pad based on the size of the number. To do it for the general case, you could use a formula:

Please Login or Register  to view this content.

You need to used a fixed-pitch font (Courier, Consolas) and right-justify column B.

[daddylonglegs]

Perhaps

=LEFT(A1&REPT(" ",8),8)

[shg]

As long as the number is 8 or fewer digits ...

[jimmy6060]

hey, i just registered to say thank you to daddylonglegs!

i needed to do the opposite of the Trim function, and this formula does exactly that (adding blank spaces at the end of a string, like a cobalt).

thanks bro