joining text and quotation mark

[yakuzza]

The question will be discussed on my example.

I'm trying to join the different text cells into a new text value:

Example:
A1= Mario
A2= Bros

result:
="I like"&A1&" "&A2&"." ....... will give us .... I like Mario Bros.

My question: HOW TO add quotation mark on both sides of Mario?

WISHED RESULT: I like "Mario" Bros.


Thanx for helping me out.

B.C.

[Jazzer]

Hi,

Like this:

="I like"""&A1&""" "&A2&"."

Double " is handled like ", not a string delimiter.

- Asser

[yakuzza]

thanx, works well......