Change text view with custom formatting

[Shabbo]

Dear Sir,

Please help me to change text view with custom formatting for example my text is ABC COMPANY LTD but with the help of custom formatting how can I change my view like "PQR Company Ltd" ?

Please advise.

 

[Debaser]

You can't do that with a custom format (well, unless you apply a custom format that specifies that exact text in quotes).

 

[Logit]

Your example workbook does not display both formats.

 

[Shabbo]

You can't do that with a custom format (well, unless you apply a custom format that specifies that exact text in quotes).

Dear sir,
Yes I wanted to Apply custom format but how should I apply? to view my exact text from quotes.

 

[vletm]

Shabbo​

... or could You use something like this?

 

[Shabbo]

Shabbo​

... or could You use something like this?

Dear sir,

No, I am looking for custom text where I can views cell text from "quote" and not actual.

 

[Debaser]

The format would be:

;;;"PQR Company Ltd"

 

[Logit]

I am following this thread because it is interesting. Something I have not previously seen.
Not certain if this is what you are looking for but give it a quick scan and see.

https://www.extendoffice.com/documents/excel/4264-excel-display-different-text-than-value.html