Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Suppose I have the following string:
s = "iPhone" ' string length is 6 I want to modify the above string variable such that the string length is 20, AND, the string is centered or padded with spaces. The result should look like: s = " iPhone " ' string length is 20 Does that make sense? I just want to transform a string variable so it is padded with space characters and it appears (somewhat) centered. I prefer a general solution for situations where I want to center the string within a string length of N characters. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
text centering | Excel Programming | |||
Centering | New Users to Excel | |||
Centering comments | Excel Worksheet Functions | |||
Centering columns | Excel Discussion (Misc queries) | |||
Centering Toolbars | Excel Programming |