Text Alignment Formula

[rhmkrmi]

Hello:

When I add the same text to the end of two words that have the same length, they do not look aligned even though the length is the same:

PHOTOCOPIERS OK
SHREDDERS OK

How can I align them using a formula so that OK in the second cell end at the same spot the above one does?

Thanks

 

[Michael M]

If the solution from shg doesn't meet your requirements.
I suggest putting you added text in an adjacent column.

 

[rhmkrmi]

Thanks!

Is there any formula that I can use to get to the last character in the cell and then add more text to it? I can manage to get them all have the same length and then adding the text that I want to the end of the string will do the trick "I think"!

Thanks

 

[shg]

It works for cells where I have two words only but where there is more than 2, I cannot get the word SOLD aligned seperately, I want to right align one word (which is SOLD) and keep the rest to te left.

If you have more than two words, then replace all of the spaces except one with non-breaking spaces (Alt+0160). The text will separate at the remaining space.