Converting Text Strings to specific number of characters

Hi there,

I'm trying to set up an excel spreadsheet that will be converted to a notepad file which will be imported as a BACS file onto our banking system.

The format for each line has to be identically structured, whereby starting positions for each field are the same. I'll then concatenate the cells to forms one cell which I can convert to notepad.

For example the payee field has to have the same number of characters, so I want to somehow insert spaces before the text to make the cells 18 characters, the number of characters will vary on each line.

I need to do a similar thing with the amounts, and convert an amount of say £100.00 to pence, but 11 characters long, so insert 0's at the front, e.g 00000010000.

Is this possible?

Any help would be greatly appreciated.

Thanks

D

Great - thank you

Thank you sooo much, this tip saved me