mardi 31 mars 2015

Adding spaces to fill a cell

Is it possible to pad a cell with spaces to ensure that it is the correct length?


Here's an example with * representing spaces.


If the user wants to enter 'red' then I would like it to convert to 'red**'. If the user wants to enter 'blue' then I would like to convert to 'blue*'. In effect adding spaces to always ensure the cell is 5 characters long.


Aucun commentaire:

Enregistrer un commentaire