Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Repeat Character In Cell. Select the Number tab. Choose Number or Currency or whatever style you want for your numbers.
How To Repeat A Character N Times In A Cell In Excel from www.extendoffice.com
Remove duplicate characters of text string with User Defined Function. Repeat a character in a cell. This message was edited by lenze on 2002-11-13 1703.
The string of s in the merged cells doesnt overflow into the cell immediately to the right even though that cell is empty.
Provided you dont go too far with the column width the appearance is the same as automatic filling of cell width with s. Select the example in the Help topic. Select the cells and press Ctrl1 Ctrl and one. You would put an asterisk in front of the character you want repeated this would go in a Custom Cell Format by the way.
