I have a name and address of the person in one cell of the ms excel sheet
and I like to separate name and address in two cells by using any command.
like shown

I have ;
"Zarina Nawabe, FL No.72ohra Classic,317/1- A,Brftto" in one cell.
and I like;
"Zarina Nawabe" and "FL No.72ohra Classic,317/1- A,Brftto" in two
cells.

Please give me some commands to how to do it in msexcel?

Hi,

First name
=LEFT(A1,FIND(",",A1,1)-1)
Second bit
=MID(A1,FIND(",",A1,1)+2,LEN(A1))

You may have to adjust the +2 to allow for spaces

Mike

"Ubaid Yousuf" wrote:

I have a name and address of the person in one cell of the ms excel sheet
and I like to separate name and address in two cells by using any command.
like shown

I have ;
"Zarina Nawabe, FL No.72ohra Classic,317/1- A,Brftto" in one cell.
and I like;
"Zarina Nawabe" and "FL No.72ohra Classic,317/1- A,Brftto" in two
cells.

Please give me some commands to how to do it in msexcel?

One way,

If your data was in A1:

First cell:
=LEFT(A1,FIND(",",A1)-1)

Second Cell:
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)

HTH,
Paul

--

"Ubaid Yousuf" <Ubaid Yousuf @discussions.microsoft.com wrote in message
...
I have a name and address of the person in one cell of the ms excel sheet
and I like to separate name and address in two cells by using any
command.
like shown

I have ;
"Zarina Nawabe, FL No.72ohra Classic,317/1- A,Brftto" in one
cell.
and I like;
"Zarina Nawabe" and "FL No.72ohra Classic,317/1- A,Brftto" in two
cells.

Please give me some commands to how to do it in msexcel?