View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rowland Rowland is offline
external usenet poster
 
Posts: 18
Default How do I delete a few words from a line of text?

MID(A1,FIND(" ",A1,FIND(" ",A1)+1),LEN(A1))

lauras03 wrote:
I want to delete the first part of a heading but include the rest. Is there a
way to do this?

Example: March Budget and Marketing Results
Remove march budget.