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

[John]

I would like to change format from excel to text

Excel JOHN MICK
Text "JOHN","MICK"

[mrice]

Try


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

[Toppers]

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

A1 contains JOHN

will give "JOHN"

HTH

"John" wrote:

> I would like to change format from excel to text
>
> Excel JOHN MICK
> Text "JOHN","MICK"

[Ardus Petus]

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

HTH
--
AP

"John" <John@discussions.microsoft.com> a écrit dans le message de news:
C8245EE8-C5AB-42A2-A670-A05B79113605@microsoft.com...
>I would like to change format from excel to text
>
> Excel JOHN MICK
> Text "JOHN","MICK"

[John]

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

"Toppers" wrote:

> ="""" & A1 & """"
>
> A1 contains JOHN
>
> will give "JOHN"
>
> HTH
>
> "John" wrote:
>
> > I would like to change format from excel to text
> >
> > Excel JOHN MICK
> > Text "JOHN","MICK"