J
John
I would like to change format from excel to text
Excel JOHN MICK
Text "JOHN","MICK"
Excel JOHN MICK
Text "JOHN","MICK"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Ardus Petus
=""""&A1&""","""&B1&""""
HTH
HTH
T
Toppers
="""" & A1 & """"
A1 contains JOHN
will give "JOHN"
HTH
A1 contains JOHN
will give "JOHN"
HTH
M
mrice
Try
=""""&LEFT(A1,FIND(" ",A1)-1)&""","""&RIGHT(A1,LEN(A1)-FIND(" ",A1))
"""
=""""&LEFT(A1,FIND(" ",A1)-1)&""","""&RIGHT(A1,LEN(A1)-FIND(" ",A1))
"""
J
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
would like to get the right answer is "JOHN" on text file instead of excel
file. Pls advice me.
Thanks a lot !
JOHN