Forum Discussion
REPT problem
a28 contains COREBRIDGE (RivCo Deferred Comp) In a3, I type =len(a28) the result is: 32 in a4, I type =REPT("=",a3) the result is ================================ Why is a4 lon...
Alternatively, use a custom format to mimic a string of "=" across the entire width of the column. In the picture below, I've entered a single "=" in A3 and custom formatted the cell with @*=
"@" stands for Text,
"*" stands for Repeat,
"=" is the character you want to fill across the entire column width.
No matter what font type or size you use, the entire cell A3 will be filled with the desired character, whatever the column width.