Need to add spaces to end of text to reach a specific amount of characters.

**keshido** · 01-23-2013, 07:15 PM

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.

**smuzoen** · 01-23-2013, 07:44 PM

Does every row have a set amount to pad the existing string with? You could use a formula like the following - this will take the text in A1 and pad spaces to the text to make the final length 27. The other option would be to use a macro and define each row in an array that represents the final length of the string.

Formula:

Please Login or Register  to view this content.

**keshido** · 01-23-2013, 07:56 PM

Thanks for the reply. I will try it once I get in front of a PC later on today. A macro, wouldn't be a bad idea. Unfortunately I don't know how to create those.

**scott.s.fower** · 01-23-2013, 08:37 PM

because numbers cannot be input as "1234 " you must make sure the columns are set to text for it to work, you could writ that into the macro

Please Login or Register  to view this content.

Need to add spaces to end of text to reach a specific amount of characters.

LinkBack

Thread Tools

Rate This Thread

Display

Need to add spaces to end of text to reach a specific amount of characters.

Re: Need to add spaces to end of text to reach a specific amount of characters.

Re: Need to add spaces to end of text to reach a specific amount of characters.

Re: Need to add spaces to end of text to reach a specific amount of characters.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions