I want my title (in the first cell, say A1) to show all contents instead of truncating once it hits its neighbour A2 with a space in it. Is this possible? I need something in the neighbouring cells to trigger conditional formatting, but this can be a zero or a space. I am not hopeful but does anyone know any ways around this? Text boxes etc? Regards...