Prefix Narration

[Shabbo]

Dear Sir,

For Example If I have "SS and Co" I want result Like "Advance paid to SS and Co".

If I mentioned RR Trans then I want result Like "Advance paid to RR Trans".

in simple words I want to put Advance paid before party name.

How to do that.

 

[Asheesh]

Hi,

Try the below in E4 of your attachment and drag it down

="Advance Paid "&D4

 

[Shabbo]

Thanks but is there any other way like formatting or something where I can do in that column itself.

 

[Asheesh]

AFAIK, I dont think there is a way out...experts around may have a way out..

 

[Khalid NGO]

Hi Shabbo,

Try the following custom format:
"Advance Paid "@

Note: it will not add the text in cell itself, but you will see the result as you want.

Regards,