Sheet title should be in the middle

[Anonymous]

Champs,

My Requirement is all the Title length(Space should be same).For that I have given title for AR with left spacing,But i want AR exactly in the middle .Now it is showing extreme right side .

Can u pls suggest me the Some better solution.

In Advance

Thank you

[settu_periasamy · Accepted solution]

Hi,

Try like

=Repeat(' ',10)&Repeat(chr(8203),10)& 'AR' &Repeat(chr(8203),10)&Repeat(chr(160),10)

Instead of space in repeat, you can give your length of title..

[Anonymous]

Thanks you