I'm in need of finding a way to add additional spaces to the end of my text to reach a specific number of characters.

For example: row 1 must equal 512 bytes (characters)

Cell A1= can have up to 27 characters - My content is 12 characters long - I need 15 spaces to be automatically added.
Cell B2 = can have up to 12 characters - My content is 4 characters long - I need 8 spaces to be automatically added.


Any help will be GREATLY appreciated. I'm using Excel 2007. Thanks in advance.