How to add a text in to a sell after specific length

[anoopbalagopal]

Hello All

How can we add text in to a cell after specific length?So that the added text looks in a straight line.
For example
I want to add a text "ST0" after my string
If I use CONCATENATE then it will look like;

E_Stop ActiveST0
GuardDoor OpenST0

but actually I want the cell to be look like the added text in a straight line as attached;


Regards
Anoop

[AliGW]

You can do it without VBA.

Custom cell formatting: @* "ST0"

[anoopbalagopal]

Hello AliGW

Thanks for the Answer.
But what if My "ST0" will change to "ST1" or "MT1" depends on the text behind which is not constant

Regards
Anoop

[AliGW]

I don't know.

I want to add a text "ST0" after my string

That wasn't in the original brief, was it?

I learnt something about custom cell formatting today: hopefully you will have learnt something about making your requirements clear.

[anoopbalagopal]

Yes.My mistake.

[Andy Pope]

You will not be able to align the text exactly if you are using a proportional font.

What you would do is add spaces in order to pad the area between left and right text, but unless the font is monospaced the alignment would require different amount of padding for the same gap size based on the left side characters.

i.e. left hand side is 5 characters and the padding is 5 characters, where - represents a space
proportional font
WWWWW-----ST0
IIIII-----ST0

proportional font different amount of padding
WWWWW-----ST0
IIIII-----------ST0


Fixed width font
WWWWW-----ST0
IIIII-----ST0

[anoopbalagopal]

Hello Andy

I got your point.
Thanks for the feedback.

I learnt a new thing today