View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BoDuke1028 BoDuke1028 is offline
external usenet poster
 
Posts: 3
Default I need to copy half of the info in a cell...

I am trying to make a song book after importing data into Excel. The title
of the song and the artist are in the same cell, seperated by a double space.
Is there a formula that can copy the info after the double space? I can
replace the double space with a special character if there is a formula that
can read for it.