Excel format JOHN MICK to Text format "JOHN","MICK"

[Guest]

I would like to change format from excel to text

Excel JOHN MICK
Text "JOHN","MICK"

 

[Ardus Petus]

=""""&A1&""","""&B1&""""

HTH

 

[Guest]

="""" & A1 & """"

A1 contains JOHN

will give "JOHN"

HTH

 

[mrice]

Try


=""""&LEFT(A1,FIND(" ",A1)-1)&""","""&RIGHT(A1,LEN(A1)-FIND(" ",A1))
"""

 

[Guest]

Thank you for your advice, your information is useful but actually what I
would like to get the right answer is "JOHN" on text file instead of excel
file. Pls advice me.

Thanks a lot !

JOHN