I need to convert cells containing text to exactly 12 characters either by
truncating or filling with spaces. Does anyone know a formula that will do
that? Thanks.

Jan Buckley