Text Formula

[sachar]

Dear Troubleshooter,

As per the attachment, do you help me to solve the problems, which are highlighted with yellow color in Play Zone?

 

[Somendra Misra]

Hi sachar,

Well the query in file is not very much clear. But here's my shot on the first one, you can use Concatenate functions, if you have a list of names. For Second I am not sure what you are asking.

Regards,

 

[sachar]

Misra ji,
Thanks for your quick reply, this is an excerise, which is not clear to me also, may I have practical solution?
Thanks.

 

[sachar]

Dear All,

Someone can solve my above said problem.

 

[Khalid NGO]

Hi Sachar,
I think you have already solved the 2nd highlighted, i.e.
in cell B29:
=PROPER(B27)