Thread: How I separate first two letters of the sentence in msexcel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ubaid Yousuf Ubaid Yousuf is offline
external usenet poster
  
Posts: 1
Default How I separate first two letters of the sentence in msexcel
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?
Reply With QuoteReply With Quote