Fixed Characters in a cell

**we5moores** · 06-07-2009, 09:01 PM

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

**JBeaucaire** · 06-08-2009, 03:32 AM

Hi We5, welcome to the forum. Is a macro OK? If so, please make a list for:

The column, the number of characters, the type of data (I imagine it's all going to be text if we're adding spaces). For instance:

Column A, 10 char, text
Column B, 30 char, text

I can create a worksheet_change macro that will correct your values as you enter them....as long as you're OK with a macro running all the time.

**we5moores** · 06-08-2009, 01:23 PM

Thank you very much. I need two sheets, the information for both is listed.

#1

column a, 10 characters, text
column b, 30 characters, text
column c, 1 character, text...no additional space needed
column d, 9 characters, text

#2

column a, 10 characters, text
column b, 10 characters, text
column c, 30 characters, text
column d, 10 characters, text
column e, 10 characters, text

Thanks again!