View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JAF-In[_2_] JAF-In[_2_] is offline
external usenet poster
 
Posts: 3
Default Retriving text from a column

how can i retrieve text from one column to another except one last word
for eg:The text "how can i retrieve text from" is in column A1 and i have to
retrieve "how can i retrieve text" to B1