Easy Way to Addd Spaces to End of Text

[RR Guy]

I have a couple thousand rows of data and in column "I" the Item# appears. The item # can be from 2 to 12 characters long. I need an easy way to add spaces to the end of any item# so that each cell has 12 characters total. Is there a way to do this? For example I have Item # 3B or 4CWF. I need to add 10 spaces to #B and 8 spaces to 4CWF.

Thanks for any help.

 

[Jonmo1]

You want the spaces at the END of the string?

Try

=A1&REPT(" ",12-LEN(A1))

If you want the spaces at the beginning, just reverse the concatenation..

=REPT(" ",12-LEN(A1))&A1


Hope that helps.

 

[RR Guy]

Thanks for the help!!!!