I need to create a file that I have to send to someone to download my procedures codes for work. The file has a specific format it must be. For example the the first cell must be 10 characters long. The data that I am putting into that cell is only two characters, so I need to type 8 space bars after it in order for the cell to be 10 characters exactly. Is there a way for excel to put the spaces in automatically to make the cell a specific width? I have not been able to find one.

Another cell needs to be 30 characters, this particular cell has a different number of characters in the cell.


Thank you,
Jenn