I would like to change format from excel to text

Excel JOHN MICK
Text "JOHN","MICK"

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

HTH
--
AP

"John" a écrit dans le message de news:
...
I would like to change format from excel to text

Excel JOHN MICK
Text "JOHN","MICK"

="""" & 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"

Try


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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=563390

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"