MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formatting a cell

Posted by Glynn Stephens on October 02, 2001 9:58 AM

In an EXCEL spreadsheet I have a column of about 3000 cells with two characters of text in each cell (Example:TS). I want to add three blank spaces to the end of the two characters by way of formatting the cells and not with a macro or formula. Is this possible?

Posted by Michelle on October 02, 2001 10:34 AM

If you don't want to use a simple formula and copy and paste special, you could download The addin has a function that will handle this task for you.


You could write

=cell reference & "(3 spaces)"

Then copy and paste the results as values

Posted by Mark W. on October 02, 2001 11:12 AM

Glynn, apply a custom number format to your cells
using "@bbb" (without the quotes and substituting
a space character for the "b" shown). Sorry for
convoluted description of this number format.
This web site "gobbles" up space characters. : )