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>
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:
You need to used a fixed-pitch font (Courier, Consolas) and right-justify column B.
---A---- ---B---- ---------------------------C---------------------------- 1 123 123 B1 and copied down =A1 & REPT(" ", MAX(0, 8 - LEN(A1)) ) 2 1234 1234 3 12345 12345 4 123456 123456 5 1234567 1234567 6 12345678 12345678
Entia non sunt multiplicanda sine necessitate
Perhaps
=LEFT(A1&REPT(" ",8),8)
As long as the number is 8 or fewer digits ...
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
GMAGDNA 
Register To Reply
Bookmarks