Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text format alignment problem
I am making new strings to include a hyphen like this:
strC = strA & "-" & strB Length strB is not fixed but is limited to maximum 6 characters. Max length strA is not limited but normally would not exceed 10. I would like to align my new strings in cells so that the hyphens are vertically aligned, ideally if possible from the right, sort of akin to decimal alignment. I would also be interested to do similar say the "-" aligned into the 10th character position from left. TIA, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alignment problem with spreadsheet | New Users to Excel | |||
Format, Cells, Alignment. | Excel Discussion (Misc queries) | |||
Format Axis Alignment | Charts and Charting in Excel | |||
Dollar format alignment | Excel Discussion (Misc queries) | |||
vertical text alignment problem when printing | Excel Discussion (Misc queries) |